PREVIEW / etf_1hour / 2007-04-12

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-04-12.parquet
  size:    70 KB
  rows:    2,193

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-04-12 05:00:00	SPY	ETF	143.68	143.68	143.68	143.68	200.0
2007-04-12 06:00:00	SPY	ETF	143.78	143.78	143.74	143.74	25000.0
2007-04-12 07:00:00	SPY	ETF	143.77	143.83	143.55	143.6	232300.0
2007-04-12 08:00:00	SPY	ETF	143.72	143.76	143.59	143.66	805000.0
2007-04-12 09:00:00	SPY	ETF	143.67	143.89	143.34	143.51	18184592.0
2007-04-12 10:00:00	SPY	ETF	143.5	144.21	143.46	144.09	26701509.0
2007-04-12 11:00:00	SPY	ETF	144.1	144.27	143.9	144.08	11960191.0
2007-04-12 12:00:00	SPY	ETF	144.09	144.53	144.05	144.28	13669889.0
2007-04-12 13:00:00	SPY	ETF	144.29	144.62	144.29	144.47	13498988.0
2007-04-12 14:00:00	SPY	ETF	144.47	144.7	144.43	144.58	11489486.0
2007-04-12 15:00:00	SPY	ETF	144.57	144.92	144.53	144.74	11453793.0
2007-04-12 16:00:00	SPY	ETF	144.74	144.76	143.99	143.99	5237100.0
2007-04-12 17:00:00	SPY	ETF	144.63	144.68	144.6	144.63	914400.0
2007-04-12 18:00:00	SPY	ETF	144.67	144.67	144.67	144.67	12300.0
2007-04-12 19:00:00	SPY	ETF	144.64	144.72	144.64	144.68	5300.0
2007-04-12 07:00:00	QQQ	ETF	44.13	44.13	44.04	44.08	745043.0
2007-04-12 08:00:00	QQQ	ETF	44.09	44.13	44.07	44.09	716706.0
2007-04-12 09:00:00	QQQ	ETF	44.09	44.19	43.95	44.08	19258297.0
2007-04-12 10:00:00	QQQ	ETF	44.07	44.47	44.07	44.42	31199100.0
2007-04-12 11:00:00	QQQ	ETF	44.42	44.48	44.18	44.4	8813100.0
2007-04-12 12:00:00	QQQ	ETF	44.4	44.56	44.39	44.51	8232900.0
2007-04-12 13:00:00	QQQ	ETF	44.51	44.62	44.5	44.55	10944600.0
2007-04-12 14:00:00	QQQ	ETF	44.55	44.58	44.44	44.51	11224900.0
2007-04-12 15:00:00	QQQ	ETF	44.5	44.61	44.21	44.61	16649900.0
2007-04-12 16:00:00	QQQ	ETF	44.6	44.61	44.5105	44.53	5309279.0
2007-04-12 17:00:00	QQQ	ETF	44.53	44.55	44.51	44.52	1119803.0
2007-04-12 18:00:00	QQQ	ETF	44.55	44.57	44.55	44.56	24700.0
2007-04-12 19:00:00	QQQ	ETF	44.56	44.57	44.56	44.57	15450.0
2007-04-12 07:00:00	IWM	ETF	80.0	80.0	80.0	80.0	500.0
2007-04-12 08:00:00	IWM	ETF	80.0	80.1	79.93	80.04	160800.0
2007-04-12 09:00:00	IWM	ETF	80.04	80.19	79.67	79.76	6070198.0
2007-04-12 10:00:00	IWM	ETF	79.76	80.35	79.74	80.28	11813052.0
2007-04-12 11:00:00	IWM	ETF	80.27	80.34	80.11	80.215	3948150.0
2007-04-12 12:00:00	IWM	ETF	80.22	80.56	80.21	80.5	4547565.0
2007-04-12 13:00:00	IWM	ETF	80.49	80.79	80.46	80.65	5202019.0
2007-04-12 14:00:00	IWM	ETF	80.64	80.81	80.61	80.64	4359320.0
2007-04-12 15:00:00	IWM	ETF	80.65	80.92	80.65	80.88	6483108.0
2007-04-12 16:00:00	IWM	ETF	80.89	80.89	80.73	80.8	1558200.0
2007-04-12 17:00:00	IWM	ETF	80.81	80.81	80.71	80.71	2082000.0
2007-04-12 07:00:00	DIA	ETF	124.6	124.6	124.54	124.54	11000.0
2007-04-12 08:00:00	DIA	ETF	124.65	124.72	124.61	124.72	9100.0
2007-04-12 09:00:00	DIA	ETF	124.79	124.86	124.26	124.38	1436198.0
2007-04-12 10:00:00	DIA	ETF	124.39	125.0	124.38	124.94	1484817.0
2007-04-12 11:00:00	DIA	ETF	124.94	125.11	124.78	124.95	601071.0
2007-04-12 12:00:00	DIA	ETF	124.94	125.22	124.94	125.15	563139.0
2007-04-12 13:00:00	DIA	ETF	125.15	125.41	125.15	125.31	727681.0
2007-04-12 14:00:00	DIA	ETF	125.31	125.49	125.25	125.4	438500.0
2007-04-12 15:00:00	DIA	ETF	125.41	125.54	125.36	125.5	628253.0
2007-04-12 16:00:00	DIA	ETF	125.49	125.49	125.34	125.41	51300.0
2007-04-12 17:00:00	DIA	ETF	125.41	125.41	125.41	125.41	42800.0

> showing 50 of 2,193 rows — these rows as CSV

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