PREVIEW / etf_1hour / 2009-10-21

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-10-21.parquet
  size:    147 KB
  rows:    4,478

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-10-21 04:00:00	SPY	ETF	109.05	109.25	109.0	109.25	1200.0
2009-10-21 05:00:00	SPY	ETF	109.15	109.15	108.73	108.73	5569.0
2009-10-21 06:00:00	SPY	ETF	108.87	108.91	108.68	108.84	53868.0
2009-10-21 07:00:00	SPY	ETF	108.86	108.86	108.56	108.77	779338.0
2009-10-21 08:00:00	SPY	ETF	108.77	109.1	108.67	109.0	3895025.0
2009-10-21 09:00:00	SPY	ETF	109.0	109.89	108.95	109.74	26673750.0
2009-10-21 10:00:00	SPY	ETF	109.73	110.31	109.715	110.02	32026723.0
2009-10-21 11:00:00	SPY	ETF	110.01	110.2	109.63	109.73	22326711.0
2009-10-21 12:00:00	SPY	ETF	109.74	109.94	109.57	109.88	12719133.0
2009-10-21 13:00:00	SPY	ETF	109.88	110.02	109.68	109.98	11247351.0
2009-10-21 14:00:00	SPY	ETF	109.98	110.01	109.57	109.86	19048305.0
2009-10-21 15:00:00	SPY	ETF	109.85	109.9	108.15	108.25	79653417.0
2009-10-21 16:00:00	SPY	ETF	108.25	110.01	107.73	108.16	13567837.0
2009-10-21 17:00:00	SPY	ETF	108.14	108.2	108.1	108.14	180615.0
2009-10-21 18:00:00	SPY	ETF	108.17	108.2	108.07	108.11	375928.0
2009-10-21 19:00:00	SPY	ETF	108.13	108.24	108.1	108.24	102153.0
2009-10-21 05:00:00	QQQ	ETF	43.14	43.14	43.05	43.05	8200.0
2009-10-21 06:00:00	QQQ	ETF	43.12	43.12	43.06	43.09	1600.0
2009-10-21 07:00:00	QQQ	ETF	43.08	43.1	43.0	43.08	191105.0
2009-10-21 08:00:00	QQQ	ETF	43.08	43.19	43.08	43.15	718588.0
2009-10-21 09:00:00	QQQ	ETF	43.16	43.58	43.15	43.52	15933184.0
2009-10-21 10:00:00	QQQ	ETF	43.53	43.82	43.51	43.65	19614546.0
2009-10-21 11:00:00	QQQ	ETF	43.65	43.7	43.44	43.49	11183899.0
2009-10-21 12:00:00	QQQ	ETF	43.49	43.6	43.42	43.56	5441575.0
2009-10-21 13:00:00	QQQ	ETF	43.56	43.7	43.49	43.68	6392575.0
2009-10-21 14:00:00	QQQ	ETF	43.68	43.7	43.5	43.6124	8700710.0
2009-10-21 15:00:00	QQQ	ETF	43.62	43.64	43.06	43.15	32486907.0
2009-10-21 16:00:00	QQQ	ETF	43.15	43.5727	43.02	43.1	5831794.0
2009-10-21 17:00:00	QQQ	ETF	43.11	43.18	43.06	43.06	314577.0
2009-10-21 18:00:00	QQQ	ETF	43.1	43.12	43.04	43.05	69518.0
2009-10-21 19:00:00	QQQ	ETF	43.06	43.09	43.04	43.09	55856.0
2009-10-21 06:00:00	IWM	ETF	61.19	61.2	61.19	61.2	3400.0
2009-10-21 07:00:00	IWM	ETF	61.14	61.16	61.01	61.13	31000.0
2009-10-21 08:00:00	IWM	ETF	61.13	61.27	61.07	61.13	464908.0
2009-10-21 09:00:00	IWM	ETF	61.12	62.12	61.11	61.99	8463526.0
2009-10-21 10:00:00	IWM	ETF	62.0	62.4	61.99	62.15	8920286.0
2009-10-21 11:00:00	IWM	ETF	62.16	62.18	61.68	61.78	5586248.0
2009-10-21 12:00:00	IWM	ETF	61.77	61.98	61.68	61.93	2156552.0
2009-10-21 13:00:00	IWM	ETF	61.935	62.03	61.78	61.9708	2256418.0
2009-10-21 14:00:00	IWM	ETF	61.98	62.03	61.72	61.91	3791278.0
2009-10-21 15:00:00	IWM	ETF	61.9	61.95	60.41	60.5	25771264.0
2009-10-21 16:00:00	IWM	ETF	60.51	61.374	59.86	60.4	4656421.0
2009-10-21 17:00:00	IWM	ETF	60.4	60.554	60.32	60.37	1470630.0
2009-10-21 18:00:00	IWM	ETF	60.4	60.42	60.36	60.4	3060.0
2009-10-21 19:00:00	IWM	ETF	60.42	60.52	60.39	60.44	2700.0
2009-10-21 07:00:00	DIA	ETF	100.05	100.1	99.83	100.1	15624.0
2009-10-21 08:00:00	DIA	ETF	100.08	100.22	99.85	100.08	34702.0
2009-10-21 09:00:00	DIA	ETF	100.15	100.88	100.12	100.74	862106.0
2009-10-21 10:00:00	DIA	ETF	100.76	101.2	100.755	100.97	1367582.0
2009-10-21 11:00:00	DIA	ETF	100.97	100.979	100.655	100.76	868485.0

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

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