PREVIEW / etf_1hour / 2008-05-23

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-05-23.parquet
  size:    106 KB
  rows:    3,446

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
2008-05-23 04:00:00	SPY	ETF	138.93	139.01	138.84	138.84	6300.0
2008-05-23 05:00:00	SPY	ETF	138.98	139.0	138.98	139.0	51200.0
2008-05-23 06:00:00	SPY	ETF	139.06	139.09	138.85	138.99	382400.0
2008-05-23 07:00:00	SPY	ETF	138.98	139.17	138.85	139.17	489143.0
2008-05-23 08:00:00	SPY	ETF	139.17	139.18	138.89	138.97	2753304.0
2008-05-23 09:00:00	SPY	ETF	138.97	139.2	138.4	138.56	19266123.0
2008-05-23 10:00:00	SPY	ETF	138.5695	139.14	137.98	138.27	35265101.0
2008-05-23 11:00:00	SPY	ETF	138.27	138.28	137.63	138.06	24094053.0
2008-05-23 12:00:00	SPY	ETF	138.05	138.21	137.57	137.63	14198453.0
2008-05-23 13:00:00	SPY	ETF	137.62	138.11	137.6	137.71	19222258.0
2008-05-23 14:00:00	SPY	ETF	137.7	139.6631	137.63	138.092	21692858.0
2008-05-23 15:00:00	SPY	ETF	138.1	138.38	137.6	137.87	28915127.0
2008-05-23 16:00:00	SPY	ETF	137.87	138.1	137.42	137.49	9461691.0
2008-05-23 17:00:00	SPY	ETF	137.47	137.61	137.4	137.46	143976.0
2008-05-23 18:00:00	SPY	ETF	137.58	137.65	137.56	137.63	14035.0
2008-05-23 19:00:00	SPY	ETF	137.6	137.68	137.6	137.67	4756.0
2008-05-23 04:00:00	QQQ	ETF	48.1	48.1	48.09	48.09	200.0
2008-05-23 06:00:00	QQQ	ETF	48.2	48.21	48.11	48.11	29700.0
2008-05-23 07:00:00	QQQ	ETF	48.13	48.28	48.13	48.28	328174.0
2008-05-23 08:00:00	QQQ	ETF	48.26	48.29	48.16	48.16	582096.0
2008-05-23 09:00:00	QQQ	ETF	48.16	48.31	48.13	48.17	15192284.0
2008-05-23 10:00:00	QQQ	ETF	48.17	48.35	48.0	48.14	20601517.0
2008-05-23 11:00:00	QQQ	ETF	48.14	48.18	47.82	48.01	22177824.0
2008-05-23 12:00:00	QQQ	ETF	48.0	48.14	47.83	47.86	14277542.0
2008-05-23 13:00:00	QQQ	ETF	47.86	48.14	47.84	47.98	11707441.0
2008-05-23 14:00:00	QQQ	ETF	47.98	48.3	47.95	48.23	11440070.0
2008-05-23 15:00:00	QQQ	ETF	48.23	48.3	48.09	48.2	18025373.0
2008-05-23 16:00:00	QQQ	ETF	48.21	48.34	48.09	48.15	4905311.0
2008-05-23 17:00:00	QQQ	ETF	48.15	48.16	48.13	48.13	28000.0
2008-05-23 18:00:00	QQQ	ETF	48.16	48.16	48.15	48.16	300.0
2008-05-23 19:00:00	QQQ	ETF	48.17	48.2	48.15	48.2	5280.0
2008-05-23 07:00:00	IWM	ETF	72.79	72.85	72.74	72.84	25676.0
2008-05-23 08:00:00	IWM	ETF	72.84	72.84	72.75	72.75	94628.0
2008-05-23 09:00:00	IWM	ETF	72.75	72.98	72.22	72.34	9215868.0
2008-05-23 10:00:00	IWM	ETF	72.35	72.53	71.73	72.13	16498113.0
2008-05-23 11:00:00	IWM	ETF	72.12	72.23	71.77	72.17	7542147.0
2008-05-23 12:00:00	IWM	ETF	72.17	72.34	71.97	71.99	3754225.0
2008-05-23 13:00:00	IWM	ETF	71.99	72.35	71.86	71.93	5747316.0
2008-05-23 14:00:00	IWM	ETF	71.93	72.43	71.89	72.28	6487419.0
2008-05-23 15:00:00	IWM	ETF	72.27	72.53	72.16	72.34	8809440.0
2008-05-23 16:00:00	IWM	ETF	72.36	72.42	72.15	72.15	2326357.0
2008-05-23 17:00:00	IWM	ETF	72.19	72.35	72.19	72.35	325.0
2008-05-23 19:00:00	IWM	ETF	72.3	72.3	72.24	72.24	502.0
2008-05-23 07:00:00	DIA	ETF	125.57	125.72	125.57	125.72	3000.0
2008-05-23 08:00:00	DIA	ETF	125.69	125.69	125.57	125.6	38924.0
2008-05-23 09:00:00	DIA	ETF	125.63	125.81	125.24	125.26	1143390.0
2008-05-23 10:00:00	DIA	ETF	125.27	125.48	124.95	125.12	2627966.0
2008-05-23 11:00:00	DIA	ETF	125.12	125.17	124.75	125.09	1454252.0
2008-05-23 12:00:00	DIA	ETF	125.08	125.21	124.6	124.66	1163361.0
2008-05-23 13:00:00	DIA	ETF	124.67	125.02	124.59	124.62	1159515.0

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

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