PREVIEW / etf_1hour / 2009-03-20

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-03-20.parquet
  size:    129 KB
  rows:    3,930

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-03-20 04:00:00	SPY	ETF	77.85	77.85	77.81	77.81	2700.0
2009-03-20 05:00:00	SPY	ETF	77.8	77.81	77.58	77.75	26225.0
2009-03-20 06:00:00	SPY	ETF	77.64	78.12	77.51	78.12	34775.0
2009-03-20 07:00:00	SPY	ETF	78.14	78.65	78.08	78.57	598325.0
2009-03-20 08:00:00	SPY	ETF	78.58	78.83	77.72	78.73	3420688.0
2009-03-20 09:00:00	SPY	ETF	78.72	78.901	78.21	78.33	44351260.0
2009-03-20 10:00:00	SPY	ETF	78.33	78.55	77.98	78.45	50780079.0
2009-03-20 11:00:00	SPY	ETF	78.455	78.91	77.89	78.1099	66180554.0
2009-03-20 12:00:00	SPY	ETF	78.11	78.38	77.47	77.64	31539051.0
2009-03-20 13:00:00	SPY	ETF	77.63	78.3	76.76	76.8	37290072.0
2009-03-20 14:00:00	SPY	ETF	76.8	77.0	76.53	76.91	47153825.0
2009-03-20 15:00:00	SPY	ETF	76.91	77.55	76.69	76.71	65052087.0
2009-03-20 16:00:00	SPY	ETF	76.67	78.05	76.62	76.99	11233729.0
2009-03-20 17:00:00	SPY	ETF	76.99	77.06	76.91	77.0	277872.0
2009-03-20 18:00:00	SPY	ETF	77.0	77.0	76.72	76.82	83635.0
2009-03-20 19:00:00	SPY	ETF	76.85	76.85	76.71	76.75	20050.0
2009-03-20 04:00:00	QQQ	ETF	29.52	29.52	29.52	29.52	100.0
2009-03-20 05:00:00	QQQ	ETF	29.53	29.53	29.52	29.52	200.0
2009-03-20 06:00:00	QQQ	ETF	29.57	29.57	29.57	29.57	100.0
2009-03-20 07:00:00	QQQ	ETF	29.6	29.71	29.56	29.69	218317.0
2009-03-20 08:00:00	QQQ	ETF	29.68	29.74	29.63	29.71	454739.0
2009-03-20 09:00:00	QQQ	ETF	29.72	30.03	29.57	29.87	23842908.0
2009-03-20 10:00:00	QQQ	ETF	29.87	29.89	29.7	29.85	16347098.0
2009-03-20 11:00:00	QQQ	ETF	29.85	29.85	29.56	29.6	15344954.0
2009-03-20 12:00:00	QQQ	ETF	29.6	29.67	29.29	29.35	12030919.0
2009-03-20 13:00:00	QQQ	ETF	29.35	29.6	29.05	29.07	16556430.0
2009-03-20 14:00:00	QQQ	ETF	29.0604	29.2	28.98	29.16	17181198.0
2009-03-20 15:00:00	QQQ	ETF	29.1676	29.39	29.14	29.18	30764747.0
2009-03-20 16:00:00	QQQ	ETF	29.18	29.6673	29.11	29.18	7423474.0
2009-03-20 17:00:00	QQQ	ETF	29.2	29.24	29.17	29.19	26775.0
2009-03-20 18:00:00	QQQ	ETF	29.18	29.19	29.16	29.17	17208.0
2009-03-20 19:00:00	QQQ	ETF	29.18	29.18	29.1	29.1	17171.0
2009-03-20 06:00:00	IWM	ETF	41.15	41.29	41.15	41.29	4200.0
2009-03-20 07:00:00	IWM	ETF	41.41	41.51	41.33	41.51	107100.0
2009-03-20 08:00:00	IWM	ETF	41.58	41.72	41.02	41.67	56484.0
2009-03-20 09:00:00	IWM	ETF	41.67	41.92	41.43	41.57	7379543.0
2009-03-20 10:00:00	IWM	ETF	41.57	41.61	41.21	41.36	8801412.0
2009-03-20 11:00:00	IWM	ETF	41.36	41.38	40.92	41.05	6448699.0
2009-03-20 12:00:00	IWM	ETF	41.04	41.21	40.69	40.73	4974542.0
2009-03-20 13:00:00	IWM	ETF	40.73	40.77	40.16	40.19	6456450.0
2009-03-20 14:00:00	IWM	ETF	40.1808	41.45	39.96	40.3	11722558.0
2009-03-20 15:00:00	IWM	ETF	40.29	40.59	40.04	40.05	15384280.0
2009-03-20 16:00:00	IWM	ETF	40.05	41.4096	39.87	40.13	4456838.0
2009-03-20 17:00:00	IWM	ETF	40.11	40.14	40.11	40.12	17400.0
2009-03-20 18:00:00	IWM	ETF	40.13	40.17	40.13	40.15	300.0
2009-03-20 19:00:00	IWM	ETF	39.96	39.96	39.96	39.96	400.0
2009-03-20 06:00:00	DIA	ETF	73.5	73.5	73.5	73.5	200.0
2009-03-20 07:00:00	DIA	ETF	73.79	74.2	73.79	74.2	13900.0
2009-03-20 08:00:00	DIA	ETF	74.19	74.43	74.02	74.32	40112.0
2009-03-20 09:00:00	DIA	ETF	74.37	74.56	74.04	74.17	3426564.0

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

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