PREVIEW / etf_1hour / 2009-02-19

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-02-19.parquet
  size:    127 KB
  rows:    3,884

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-02-19 04:00:00	SPY	ETF	79.16	79.44	79.16	79.39	2850.0
2009-02-19 05:00:00	SPY	ETF	79.29	79.48	79.29	79.31	5507.0
2009-02-19 06:00:00	SPY	ETF	79.2	79.3	79.16	79.18	42200.0
2009-02-19 07:00:00	SPY	ETF	79.2	79.69	79.15	79.65	1647574.0
2009-02-19 08:00:00	SPY	ETF	79.4	79.89	78.56	79.7	4833902.0
2009-02-19 09:00:00	SPY	ETF	79.7	80.15	79.65	80.02	36863398.0
2009-02-19 10:00:00	SPY	ETF	80.02	80.05	79.18	79.23	47610637.0
2009-02-19 11:00:00	SPY	ETF	79.22	79.84	78.79	78.85	36657142.0
2009-02-19 12:00:00	SPY	ETF	78.86	79.0	78.51	78.88	29364141.0
2009-02-19 13:00:00	SPY	ETF	78.88	79.46	78.72	78.94	29866551.0
2009-02-19 14:00:00	SPY	ETF	78.94	79.21	78.47	78.76	35834281.0
2009-02-19 15:00:00	SPY	ETF	78.75	79.3	78.02	78.28	69782140.0
2009-02-19 16:00:00	SPY	ETF	78.27	79.1858	77.96	78.21	22637805.0
2009-02-19 17:00:00	SPY	ETF	78.23	78.35	78.2	78.26	211500.0
2009-02-19 18:00:00	SPY	ETF	78.26	79.1858	78.14	78.27	1050345.0
2009-02-19 19:00:00	SPY	ETF	78.35	78.37	78.04	78.07	45203.0
2009-02-19 04:00:00	QQQ	ETF	29.27	29.27	29.27	29.27	675.0
2009-02-19 05:00:00	QQQ	ETF	29.31	29.31	29.31	29.31	100.0
2009-02-19 06:00:00	QQQ	ETF	29.23	29.29	29.23	29.25	26275.0
2009-02-19 07:00:00	QQQ	ETF	29.25	29.4	29.23	29.4	719360.0
2009-02-19 08:00:00	QQQ	ETF	29.29	29.46	29.24	29.44	3896789.0
2009-02-19 09:00:00	QQQ	ETF	29.43	29.61	29.3701	29.52	21836353.0
2009-02-19 10:00:00	QQQ	ETF	29.51	29.55	29.05	29.08	28495558.0
2009-02-19 11:00:00	QQQ	ETF	29.08	29.25	28.9301	28.9711	17196076.0
2009-02-19 12:00:00	QQQ	ETF	28.9799	29.07	28.83	29.0	12506553.0
2009-02-19 13:00:00	QQQ	ETF	29.01	29.19	28.93	29.0099	10723137.0
2009-02-19 14:00:00	QQQ	ETF	29.01	29.11	28.84	28.94	14050222.0
2009-02-19 15:00:00	QQQ	ETF	28.94	29.0	28.72	28.78	31022703.0
2009-02-19 16:00:00	QQQ	ETF	28.78	28.89	28.72	28.79	6202962.0
2009-02-19 17:00:00	QQQ	ETF	28.77	29.2725	28.77	28.8	6089682.0
2009-02-19 18:00:00	QQQ	ETF	28.79	28.83	28.76	28.79	22309.0
2009-02-19 19:00:00	QQQ	ETF	28.78	28.78	28.71	28.71	35340.0
2009-02-19 07:00:00	IWM	ETF	42.41	42.6	42.38	42.6	70422.0
2009-02-19 08:00:00	IWM	ETF	42.58	42.75	42.35	42.67	550258.0
2009-02-19 09:00:00	IWM	ETF	42.68	43.0	42.65	42.8	6250522.0
2009-02-19 10:00:00	IWM	ETF	42.8	42.82	42.27	42.45	9677860.0
2009-02-19 11:00:00	IWM	ETF	42.45	42.69	42.05	42.07	7917103.0
2009-02-19 12:00:00	IWM	ETF	42.07	42.27	41.85	42.16	5346155.0
2009-02-19 13:00:00	IWM	ETF	42.17	42.56	42.09	42.26	5136171.0
2009-02-19 14:00:00	IWM	ETF	42.25	42.41	41.9117	42.05	5567907.0
2009-02-19 15:00:00	IWM	ETF	42.05	42.13	41.63	41.692	13503982.0
2009-02-19 16:00:00	IWM	ETF	41.7	41.83	41.63	41.72	3790639.0
2009-02-19 17:00:00	IWM	ETF	41.76	42.3077	41.71	41.71	4513299.0
2009-02-19 05:00:00	DIA	ETF	76.17	76.17	76.06	76.06	200.0
2009-02-19 06:00:00	DIA	ETF	75.95	75.95	75.95	75.95	100.0
2009-02-19 07:00:00	DIA	ETF	75.87	76.25	75.87	76.25	20404.0
2009-02-19 08:00:00	DIA	ETF	76.26	76.44	75.87	76.29	248105.0
2009-02-19 09:00:00	DIA	ETF	76.29	76.66	76.19	76.37	4325464.0
2009-02-19 10:00:00	DIA	ETF	76.36	76.42	75.68	75.6894	4931253.0
2009-02-19 11:00:00	DIA	ETF	75.7	76.16	75.27	75.34	3828744.0

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

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