PREVIEW / etf_1hour / 2009-12-28

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-12-28.parquet
  size:    146 KB
  rows:    4,588

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
2009-12-28 04:00:00	SPY	ETF	112.64	112.65	112.64	112.65	2376.0
2009-12-28 05:00:00	SPY	ETF	112.7	112.7	112.7	112.7	2000.0
2009-12-28 06:00:00	SPY	ETF	112.7	112.7	112.67	112.7	11700.0
2009-12-28 07:00:00	SPY	ETF	112.74	112.76	112.59	112.73	45156.0
2009-12-28 08:00:00	SPY	ETF	112.72	112.85	112.45	112.84	458448.0
2009-12-28 09:00:00	SPY	ETF	112.8	112.99	112.77	112.83	9504571.0
2009-12-28 10:00:00	SPY	ETF	112.83	112.86	112.59	112.65	13313418.0
2009-12-28 11:00:00	SPY	ETF	112.65	112.75	112.62	112.6801	6934185.0
2009-12-28 12:00:00	SPY	ETF	112.69	112.7	112.6087	112.6898	2724267.0
2009-12-28 13:00:00	SPY	ETF	112.68	112.75	112.57	112.62	3999462.0
2009-12-28 14:00:00	SPY	ETF	112.63	112.65	112.32	112.43	9079545.0
2009-12-28 15:00:00	SPY	ETF	112.44	112.76	112.38	112.74	18699819.0
2009-12-28 16:00:00	SPY	ETF	112.74	112.9	112.32	112.68	20666426.0
2009-12-28 17:00:00	SPY	ETF	112.68	112.7	112.64	112.66	828750.0
2009-12-28 18:00:00	SPY	ETF	112.64	112.73	112.62	112.71	119595.0
2009-12-28 19:00:00	SPY	ETF	112.72	112.78	112.7	112.75	14725.0
2009-12-28 04:00:00	QQQ	ETF	45.98	46.08	45.98	46.07	1113.0
2009-12-28 05:00:00	QQQ	ETF	46.13	46.13	46.13	46.13	10800.0
2009-12-28 06:00:00	QQQ	ETF	46.11	46.12	46.1	46.12	10000.0
2009-12-28 07:00:00	QQQ	ETF	46.13	46.13	46.06	46.08	71333.0
2009-12-28 08:00:00	QQQ	ETF	46.07	46.1	45.97	46.08	457337.0
2009-12-28 09:00:00	QQQ	ETF	46.07	46.3	46.04	46.2	10512337.0
2009-12-28 10:00:00	QQQ	ETF	46.2	46.25	46.14	46.21	5988957.0
2009-12-28 11:00:00	QQQ	ETF	46.2	46.22	46.16	46.18	3416234.0
2009-12-28 12:00:00	QQQ	ETF	46.1801	46.21	46.16	46.19	2262732.0
2009-12-28 13:00:00	QQQ	ETF	46.18	46.22	46.14	46.16	2608108.0
2009-12-28 14:00:00	QQQ	ETF	46.16	46.1725	45.94	46.06	6163892.0
2009-12-28 15:00:00	QQQ	ETF	46.06	46.21	46.0	46.21	9357733.0
2009-12-28 16:00:00	QQQ	ETF	46.21	46.22	45.9723	46.12	6398702.0
2009-12-28 17:00:00	QQQ	ETF	46.11	46.12	46.1	46.12	9950.0
2009-12-28 18:00:00	QQQ	ETF	46.1	46.12	46.1	46.12	8175.0
2009-12-28 19:00:00	QQQ	ETF	46.13	46.16	46.12	46.16	25890.0
2009-12-28 07:00:00	IWM	ETF	63.46	63.46	63.46	63.46	3000.0
2009-12-28 08:00:00	IWM	ETF	63.48	63.58	63.12	63.56	91719.0
2009-12-28 09:00:00	IWM	ETF	63.56	63.61	63.37	63.42	5538588.0
2009-12-28 10:00:00	IWM	ETF	63.42	63.42	63.19	63.29	4229330.0
2009-12-28 11:00:00	IWM	ETF	63.3	63.36	63.125	63.29	3065797.0
2009-12-28 12:00:00	IWM	ETF	63.29	63.3	63.2	63.26	1493155.0
2009-12-28 13:00:00	IWM	ETF	63.255	63.31	63.17	63.18	2177773.0
2009-12-28 14:00:00	IWM	ETF	63.19	63.21	62.97	63.135	3610035.0
2009-12-28 15:00:00	IWM	ETF	63.15	63.31	63.02	63.3	9368795.0
2009-12-28 16:00:00	IWM	ETF	63.3	63.35	63.2	63.3	1829676.0
2009-12-28 17:00:00	IWM	ETF	63.34	63.34	63.32	63.33	6800.0
2009-12-28 18:00:00	IWM	ETF	63.27	63.38	63.26	63.36	7700.0
2009-12-28 07:00:00	DIA	ETF	105.31	105.4	105.31	105.4	400.0
2009-12-28 08:00:00	DIA	ETF	105.15	105.22	105.15	105.17	4300.0
2009-12-28 09:00:00	DIA	ETF	105.21	105.35	105.2	105.2298	809128.0
2009-12-28 10:00:00	DIA	ETF	105.23	105.26	105.09	105.15	1116574.0
2009-12-28 11:00:00	DIA	ETF	105.15	105.22	105.1399	105.18	1145984.0
2009-12-28 12:00:00	DIA	ETF	105.18	105.25	105.13	105.17	912699.0

> showing 50 of 4,588 rows — these rows as CSV

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