PREVIEW / etf_1hour / 2009-09-28

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-09-28.parquet
  size:    142 KB
  rows:    4,342

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-09-28 04:00:00	SPY	ETF	104.26	104.6	104.26	104.6	4973.0
2009-09-28 05:00:00	SPY	ETF	104.6	104.61	104.56	104.56	300.0
2009-09-28 06:00:00	SPY	ETF	104.72	104.82	104.72	104.79	4800.0
2009-09-28 07:00:00	SPY	ETF	104.8	104.99	104.74	104.92	300506.0
2009-09-28 08:00:00	SPY	ETF	104.9	105.22	104.1	104.97	1488151.0
2009-09-28 09:00:00	SPY	ETF	104.96	105.71	104.83	105.6	18728982.0
2009-09-28 10:00:00	SPY	ETF	105.59	106.15	105.59	106.01	22792938.0
2009-09-28 11:00:00	SPY	ETF	106.0	106.34	105.99	106.25	10936743.0
2009-09-28 12:00:00	SPY	ETF	106.2401	106.47	106.2	106.22	10314664.0
2009-09-28 13:00:00	SPY	ETF	106.21	106.55	106.21	106.27	9564060.0
2009-09-28 14:00:00	SPY	ETF	106.27	106.46	106.15	106.17	13960993.0
2009-09-28 15:00:00	SPY	ETF	106.17	106.37	106.01	106.31	21768879.0
2009-09-28 16:00:00	SPY	ETF	106.31	106.45	105.16	106.42	5661915.0
2009-09-28 17:00:00	SPY	ETF	106.4	106.46	106.345	106.41	227869.0
2009-09-28 18:00:00	SPY	ETF	106.38	106.44	106.38	106.44	21067.0
2009-09-28 19:00:00	SPY	ETF	106.12	106.53	106.12	106.44	101106.0
2009-09-28 20:00:00	SPY	ETF	106.48	106.48	106.48	106.48	500.0
2009-09-28 04:00:00	QQQ	ETF	41.7	41.84	41.7	41.84	500.0
2009-09-28 05:00:00	QQQ	ETF	41.81	41.81	41.81	41.81	200.0
2009-09-28 06:00:00	QQQ	ETF	41.79	41.9	41.79	41.87	8500.0
2009-09-28 07:00:00	QQQ	ETF	41.9	41.97	41.9	41.91	161331.0
2009-09-28 08:00:00	QQQ	ETF	41.92	42.06	41.77	41.95	591110.0
2009-09-28 09:00:00	QQQ	ETF	41.95	42.31	41.89	42.25	17680746.0
2009-09-28 10:00:00	QQQ	ETF	42.26	42.53	42.26	42.49	12533138.0
2009-09-28 11:00:00	QQQ	ETF	42.49	42.62	42.46	42.58	7379468.0
2009-09-28 12:00:00	QQQ	ETF	42.58	42.66	42.53	42.54	4263197.0
2009-09-28 13:00:00	QQQ	ETF	42.55	42.64	42.48	42.49	6059342.0
2009-09-28 14:00:00	QQQ	ETF	42.495	42.52	42.41	42.44	9120967.0
2009-09-28 15:00:00	QQQ	ETF	42.448	42.5	42.33	42.42	14782805.0
2009-09-28 16:00:00	QQQ	ETF	42.42	42.48	41.675	42.42	7138034.0
2009-09-28 17:00:00	QQQ	ETF	42.42	42.47	41.6751	42.43	1031917.0
2009-09-28 18:00:00	QQQ	ETF	42.44	42.48	42.42	42.42	147652.0
2009-09-28 19:00:00	QQQ	ETF	42.44	42.48	42.43	42.47	16357.0
2009-09-28 07:00:00	IWM	ETF	60.13	60.25	60.13	60.2	8230.0
2009-09-28 08:00:00	IWM	ETF	60.15	60.43	60.15	60.26	199262.0
2009-09-28 09:00:00	IWM	ETF	60.25	60.92	60.04	60.8	6895124.0
2009-09-28 10:00:00	IWM	ETF	60.8	61.33	60.8	61.17	7286263.0
2009-09-28 11:00:00	IWM	ETF	61.18	61.39	61.14	61.33	3013135.0
2009-09-28 12:00:00	IWM	ETF	61.32	61.51	61.31	61.39	3822146.0
2009-09-28 13:00:00	IWM	ETF	61.4	61.58	61.36	61.381	3721639.0
2009-09-28 14:00:00	IWM	ETF	61.38	61.47	61.32	61.33	4666142.0
2009-09-28 15:00:00	IWM	ETF	61.34	61.39	61.11	61.3	8522036.0
2009-09-28 16:00:00	IWM	ETF	61.29	61.3127	59.8881	61.28	5585827.0
2009-09-28 17:00:00	IWM	ETF	61.3	61.33	61.28	61.33	1550.0
2009-09-28 18:00:00	IWM	ETF	61.31	61.36	61.29	61.29	1700.0
2009-09-28 19:00:00	IWM	ETF	61.3	61.45	61.3	61.45	1200.0
2009-09-28 07:00:00	DIA	ETF	96.99	97.08	96.99	97.08	1000.0
2009-09-28 08:00:00	DIA	ETF	97.04	97.32	97.04	97.14	21988.0
2009-09-28 09:00:00	DIA	ETF	97.06	97.65	96.9474	97.57	1367524.0
2009-09-28 10:00:00	DIA	ETF	97.57	98.02	97.57	97.8925	1269909.0

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

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