PREVIEW / etf_1hour / 2009-03-18

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-03-18.parquet
  size:    133 KB
  rows:    4,077

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-18 04:00:00	SPY	ETF	78.26	78.29	78.07	78.07	900.0
2009-03-18 05:00:00	SPY	ETF	77.99	78.06	77.74	77.8	9800.0
2009-03-18 06:00:00	SPY	ETF	77.92	78.04	77.9	77.9	52400.0
2009-03-18 07:00:00	SPY	ETF	77.98	78.26	77.88	77.9	483252.0
2009-03-18 08:00:00	SPY	ETF	77.91	78.12	77.73	77.85	2253697.0
2009-03-18 09:00:00	SPY	ETF	77.86	78.0	77.4406	77.71	34766157.0
2009-03-18 10:00:00	SPY	ETF	77.71	77.83	77.07	77.7401	56363397.0
2009-03-18 11:00:00	SPY	ETF	77.74	77.88	77.36	77.83	30398338.0
2009-03-18 12:00:00	SPY	ETF	77.83	78.35	77.1	78.28	42894961.0
2009-03-18 13:00:00	SPY	ETF	78.28	78.64	77.99	78.37	31306716.0
2009-03-18 14:00:00	SPY	ETF	78.36	80.9	77.7	80.6	130992494.0
2009-03-18 15:00:00	SPY	ETF	80.6	80.63	78.9	79.89	116280689.0
2009-03-18 16:00:00	SPY	ETF	79.89	80.2128	77.1483	80.05	19712754.0
2009-03-18 17:00:00	SPY	ETF	80.05	80.1	79.92	79.98	7201234.0
2009-03-18 18:00:00	SPY	ETF	79.95	79.96	79.67	79.73	219067.0
2009-03-18 19:00:00	SPY	ETF	79.73	79.83	79.69	79.69	91427.0
2009-03-18 05:00:00	QQQ	ETF	29.25	29.25	29.25	29.25	200.0
2009-03-18 06:00:00	QQQ	ETF	29.29	29.3	29.26	29.28	37015.0
2009-03-18 07:00:00	QQQ	ETF	29.26	29.41	29.26	29.28	410716.0
2009-03-18 08:00:00	QQQ	ETF	29.28	29.31	29.25	29.28	823150.0
2009-03-18 09:00:00	QQQ	ETF	29.28	29.43	29.18	29.34	13515246.0
2009-03-18 10:00:00	QQQ	ETF	29.34	29.41	29.08	29.31	20890322.0
2009-03-18 11:00:00	QQQ	ETF	29.3	29.36	29.14	29.35	14251679.0
2009-03-18 12:00:00	QQQ	ETF	29.35	29.54	29.2	29.52	15432064.0
2009-03-18 13:00:00	QQQ	ETF	29.52	29.59	29.39	29.5	15575775.0
2009-03-18 14:00:00	QQQ	ETF	29.5	30.2	29.45	30.11	58691606.0
2009-03-18 15:00:00	QQQ	ETF	30.11	30.11	29.47	29.7	48148145.0
2009-03-18 16:00:00	QQQ	ETF	29.7	29.95	29.2	29.9	10349995.0
2009-03-18 17:00:00	QQQ	ETF	29.9	29.92	29.86	29.89	100827.0
2009-03-18 18:00:00	QQQ	ETF	29.91	29.91	29.83	29.84	87841.0
2009-03-18 19:00:00	QQQ	ETF	29.84	29.87	29.83	29.85	46165.0
2009-03-18 05:00:00	IWM	ETF	40.51	40.51	40.51	40.51	200.0
2009-03-18 06:00:00	IWM	ETF	40.46	40.46	40.41	40.41	400.0
2009-03-18 07:00:00	IWM	ETF	40.36	40.52	40.32	40.33	57171.0
2009-03-18 08:00:00	IWM	ETF	40.39	40.47	40.29	40.34	181957.0
2009-03-18 09:00:00	IWM	ETF	40.33	40.53	40.06	40.37	5936474.0
2009-03-18 10:00:00	IWM	ETF	40.36	40.54	39.91	40.37	9498768.0
2009-03-18 11:00:00	IWM	ETF	40.3701	40.58	40.18	40.58	4041945.0
2009-03-18 12:00:00	IWM	ETF	40.58	40.98	40.58	40.95	8625442.0
2009-03-18 13:00:00	IWM	ETF	40.94	41.24	40.82	41.06	7728075.0
2009-03-18 14:00:00	IWM	ETF	41.06	42.18	41.0	42.05	31963286.0
2009-03-18 15:00:00	IWM	ETF	42.05	42.07	40.96	41.88	29141690.0
2009-03-18 16:00:00	IWM	ETF	41.86	42.08	40.2807	41.95	5233618.0
2009-03-18 17:00:00	IWM	ETF	41.96	42.0	41.89	41.99	1518300.0
2009-03-18 18:00:00	IWM	ETF	41.88	41.95	41.84	41.84	700.0
2009-03-18 19:00:00	IWM	ETF	41.81	41.98	41.76	41.81	600.0
2009-03-18 06:00:00	DIA	ETF	73.71	73.76	73.71	73.76	1330.0
2009-03-18 07:00:00	DIA	ETF	73.78	73.84	73.61	73.62	7900.0
2009-03-18 08:00:00	DIA	ETF	73.62	73.76	73.48	73.61	62034.0
2009-03-18 09:00:00	DIA	ETF	73.52	73.63	73.13	73.2787	2111616.0

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

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