PREVIEW / etf_1hour / 2009-08-18

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-08-18.parquet
  size:    142 KB
  rows:    4,345

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-08-18 04:00:00	SPY	ETF	98.7	98.97	98.7	98.95	20120.0
2009-08-18 05:00:00	SPY	ETF	98.93	99.02	98.78	98.8	68025.0
2009-08-18 06:00:00	SPY	ETF	98.85	99.0	98.84	98.94	124500.0
2009-08-18 07:00:00	SPY	ETF	98.9	98.92	98.72	98.84	595071.0
2009-08-18 08:00:00	SPY	ETF	98.83	98.97	98.48	98.52	3777695.0
2009-08-18 09:00:00	SPY	ETF	98.52	98.93	98.35	98.535	25512608.0
2009-08-18 10:00:00	SPY	ETF	98.52	98.97	98.51	98.6896	32300667.0
2009-08-18 11:00:00	SPY	ETF	98.68	99.2	98.68	99.13	25559770.0
2009-08-18 12:00:00	SPY	ETF	99.12	99.37	98.65	99.22	18087785.0
2009-08-18 13:00:00	SPY	ETF	99.22	99.35	99.01	99.16	16613725.0
2009-08-18 14:00:00	SPY	ETF	99.16	99.41	99.15	99.22	12312233.0
2009-08-18 15:00:00	SPY	ETF	99.22	99.44	99.11	99.19	27975444.0
2009-08-18 16:00:00	SPY	ETF	99.18	99.47	98.55	99.34	9446744.0
2009-08-18 17:00:00	SPY	ETF	99.34	99.39	99.23	99.27	208603.0
2009-08-18 18:00:00	SPY	ETF	99.26	99.31	99.16	99.27	52019.0
2009-08-18 19:00:00	SPY	ETF	99.27	99.33	99.25	99.33	14584.0
2009-08-18 04:00:00	QQQ	ETF	38.78	38.85	38.78	38.85	1802.0
2009-08-18 05:00:00	QQQ	ETF	38.86	38.88	38.82	38.83	7185.0
2009-08-18 06:00:00	QQQ	ETF	38.85	38.89	38.85	38.88	8000.0
2009-08-18 07:00:00	QQQ	ETF	38.84	38.87	38.79	38.85	193450.0
2009-08-18 08:00:00	QQQ	ETF	38.85	38.88	38.7	38.71	1440342.0
2009-08-18 09:00:00	QQQ	ETF	38.71	38.85	38.61	38.68	12821965.0
2009-08-18 10:00:00	QQQ	ETF	38.68	38.85	38.68	38.74	13154895.0
2009-08-18 11:00:00	QQQ	ETF	38.74	38.98	38.74	38.93	10314022.0
2009-08-18 12:00:00	QQQ	ETF	38.94	39.98	38.92	39.0	5841960.0
2009-08-18 13:00:00	QQQ	ETF	39.0	39.05	38.91	38.96	6693242.0
2009-08-18 14:00:00	QQQ	ETF	38.961	39.07	38.95	39.0	4871166.0
2009-08-18 15:00:00	QQQ	ETF	39.01	39.11	38.99	39.02	18441420.0
2009-08-18 16:00:00	QQQ	ETF	39.02	39.0926	38.91	39.0	7881608.0
2009-08-18 17:00:00	QQQ	ETF	39.0	39.03	38.94	38.96	580409.0
2009-08-18 18:00:00	QQQ	ETF	38.96	39.04	38.95	38.97	200218.0
2009-08-18 19:00:00	QQQ	ETF	38.97	38.98	38.96	38.98	94509.0
2009-08-18 06:00:00	IWM	ETF	55.34	55.39	55.33	55.36	8697.0
2009-08-18 07:00:00	IWM	ETF	55.33	55.36	55.25	55.33	44697.0
2009-08-18 08:00:00	IWM	ETF	55.32	55.4	55.15	55.17	344843.0
2009-08-18 09:00:00	IWM	ETF	55.15	55.44	54.915	54.95	4884633.0
2009-08-18 10:00:00	IWM	ETF	54.95	55.33	54.95	55.2602	6338516.0
2009-08-18 11:00:00	IWM	ETF	55.26	55.8	55.245	55.71	6657120.0
2009-08-18 12:00:00	IWM	ETF	55.72	55.88	55.69	55.81	2894642.0
2009-08-18 13:00:00	IWM	ETF	55.82	55.89	55.66	55.77	2834463.0
2009-08-18 14:00:00	IWM	ETF	55.7799	55.85	55.68	55.68	1801819.0
2009-08-18 15:00:00	IWM	ETF	55.69	55.84	55.55	55.62	6668824.0
2009-08-18 16:00:00	IWM	ETF	55.61	55.81	55.52	55.7	2299036.0
2009-08-18 17:00:00	IWM	ETF	55.69	55.71	55.68	55.7	8226.0
2009-08-18 18:00:00	IWM	ETF	55.65	55.71	55.6	55.62	4524.0
2009-08-18 19:00:00	IWM	ETF	55.64	55.78	55.64	55.65	2000.0
2009-08-18 05:00:00	DIA	ETF	92.05	92.05	92.05	92.05	100.0
2009-08-18 07:00:00	DIA	ETF	92.06	92.2	92.06	92.16	17250.0
2009-08-18 08:00:00	DIA	ETF	92.15	92.27	91.88	91.91	75786.0
2009-08-18 09:00:00	DIA	ETF	91.95	92.1	91.75	91.89	1374698.0

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

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