PREVIEW / etf_1hour / 2007-07-26

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-07-26.parquet
  size:    95 KB
  rows:    3,166

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2007-07-26 04:00:00	SPY	ETF	151.16	151.29	151.16	151.25	6300.0
2007-07-26 05:00:00	SPY	ETF	151.36	151.36	151.36	151.36	6000.0
2007-07-26 06:00:00	SPY	ETF	151.1	151.25	150.96	150.97	317300.0
2007-07-26 07:00:00	SPY	ETF	150.94	151.02	149.77	150.3	5014400.0
2007-07-26 08:00:00	SPY	ETF	150.35	151.0	149.87	149.88	20319800.0
2007-07-26 09:00:00	SPY	ETF	150.11	150.44	149.53	150.2	41769075.0
2007-07-26 10:00:00	SPY	ETF	150.2	150.8	149.65	150.09	43343886.0
2007-07-26 11:00:00	SPY	ETF	150.09	150.09	148.33	149.23	64574112.0
2007-07-26 12:00:00	SPY	ETF	149.24	149.4	147.67	148.53	56452912.0
2007-07-26 13:00:00	SPY	ETF	148.53	148.98	147.54	147.73	45015280.0
2007-07-26 14:00:00	SPY	ETF	147.73	148.09	146.39	147.14	70898470.0
2007-07-26 15:00:00	SPY	ETF	147.14	148.8	146.97	148.54	88692858.0
2007-07-26 16:00:00	SPY	ETF	148.51	148.67	147.87	148.24	13435500.0
2007-07-26 17:00:00	SPY	ETF	148.27	148.62	148.1	148.32	2154300.0
2007-07-26 18:00:00	SPY	ETF	148.35	148.39	148.04	148.28	2287600.0
2007-07-26 19:00:00	SPY	ETF	148.28	148.32	147.42	148.03	114800.0
2007-07-26 04:00:00	QQQ	ETF	49.59	49.61	49.58	49.58	2900.0
2007-07-26 06:00:00	QQQ	ETF	49.47	49.47	49.3	49.3	411700.0
2007-07-26 07:00:00	QQQ	ETF	49.3	49.3	48.88	49.1	2105417.0
2007-07-26 08:00:00	QQQ	ETF	49.12	49.22	48.93	48.98	6713367.0
2007-07-26 09:00:00	QQQ	ETF	48.97	49.28	48.93	49.25	23748057.0
2007-07-26 10:00:00	QQQ	ETF	49.26	49.47	49.17	49.35	31276343.0
2007-07-26 11:00:00	QQQ	ETF	49.3405	49.92	48.78	49.05	44765548.0
2007-07-26 12:00:00	QQQ	ETF	49.0501	49.08	48.4201	48.69	44820479.0
2007-07-26 13:00:00	QQQ	ETF	48.69	48.81	48.38	48.4	37672542.0
2007-07-26 14:00:00	QQQ	ETF	48.4	48.51	48.05	48.335	44936199.0
2007-07-26 15:00:00	QQQ	ETF	48.335	48.98	48.25	48.97	60959677.0
2007-07-26 16:00:00	QQQ	ETF	48.97	49.4	48.31	48.84	6986031.0
2007-07-26 17:00:00	QQQ	ETF	48.85	48.98	48.8	48.85	5053607.0
2007-07-26 18:00:00	QQQ	ETF	48.84	48.92	48.8	48.87	59001.0
2007-07-26 19:00:00	QQQ	ETF	48.87	48.92	48.82	48.82	67232.0
2007-07-26 07:00:00	IWM	ETF	80.23	80.55	79.59	79.68	876000.0
2007-07-26 08:00:00	IWM	ETF	79.68	80.1	79.25	79.33	5291500.0
2007-07-26 09:00:00	IWM	ETF	79.32	80.1	78.95	79.65	29128616.0
2007-07-26 10:00:00	IWM	ETF	79.64	80.13	79.3	79.47	28275312.0
2007-07-26 11:00:00	IWM	ETF	79.47	79.47	78.56	78.91	28999929.0
2007-07-26 12:00:00	IWM	ETF	78.9	79.0	77.97	78.6	30601317.0
2007-07-26 13:00:00	IWM	ETF	78.6	78.89	78.11	78.12	30506713.0
2007-07-26 14:00:00	IWM	ETF	78.13	78.39	77.55	77.96	28908532.0
2007-07-26 15:00:00	IWM	ETF	77.96	79.03	77.89	78.72	37675898.0
2007-07-26 16:00:00	IWM	ETF	78.72	78.77	78.42	78.68	12383400.0
2007-07-26 17:00:00	IWM	ETF	78.46	78.72	78.46	78.6	2005200.0
2007-07-26 18:00:00	IWM	ETF	78.73	78.73	78.73	78.73	300.0
2007-07-26 19:00:00	IWM	ETF	78.68	78.68	78.68	78.68	100.0
2007-07-26 07:00:00	DIA	ETF	137.1	137.1	136.47	136.73	71600.0
2007-07-26 08:00:00	DIA	ETF	136.73	136.76	136.4	136.54	678000.0
2007-07-26 09:00:00	DIA	ETF	136.48	136.85	136.13	136.68	4053300.0
2007-07-26 10:00:00	DIA	ETF	136.69	137.14	136.41	136.51	4213800.0
2007-07-26 11:00:00	DIA	ETF	136.51	136.51	135.25	135.84	6572400.0
2007-07-26 12:00:00	DIA	ETF	135.85	136.0	134.51	135.08	6377400.0

> showing 50 of 3,166 rows — these rows as CSV

> unlock the full archive -- $79 one-time