PREVIEW / etf_1hour / 2009-02-04

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-02-04.parquet
  size:    126 KB
  rows:    3,846

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-04 04:00:00	SPY	ETF	83.61	83.98	83.61	83.98	600.0
2009-02-04 05:00:00	SPY	ETF	84.1	84.11	83.9	83.9	840.0
2009-02-04 06:00:00	SPY	ETF	83.85	83.85	83.56	83.56	82740.0
2009-02-04 07:00:00	SPY	ETF	83.73	83.94	83.59	83.84	734053.0
2009-02-04 08:00:00	SPY	ETF	83.83	84.48	83.73	84.08	4330272.0
2009-02-04 09:00:00	SPY	ETF	84.08	84.84	83.3	84.76	28589044.0
2009-02-04 10:00:00	SPY	ETF	84.76	85.37	84.75	85.09	51993211.0
2009-02-04 11:00:00	SPY	ETF	85.09	85.17	84.64	84.71	31213713.0
2009-02-04 12:00:00	SPY	ETF	84.71	84.9	84.4	84.47	23516982.0
2009-02-04 13:00:00	SPY	ETF	84.47	84.56	83.18	83.57	50317451.0
2009-02-04 14:00:00	SPY	ETF	83.93	84.75	83.04	83.71	57457592.0
2009-02-04 15:00:00	SPY	ETF	83.705	84.36	83.25	83.31	56430812.0
2009-02-04 16:00:00	SPY	ETF	83.3	84.26	83.09	83.1	12366159.0
2009-02-04 17:00:00	SPY	ETF	83.08	83.33	82.8	82.92	3070266.0
2009-02-04 18:00:00	SPY	ETF	82.93	83.72	82.9	83.05	157937.0
2009-02-04 19:00:00	SPY	ETF	83.06	83.06	82.81	82.83	83552.0
2009-02-04 04:00:00	QQQ	ETF	29.74	29.83	29.74	29.83	1800.0
2009-02-04 06:00:00	QQQ	ETF	29.82	29.83	29.68	29.75	24100.0
2009-02-04 07:00:00	QQQ	ETF	29.78	29.88	29.74	29.79	344533.0
2009-02-04 08:00:00	QQQ	ETF	29.83	29.98	29.71	29.9	2732103.0
2009-02-04 09:00:00	QQQ	ETF	29.89	30.36	29.84	30.33	23172458.0
2009-02-04 10:00:00	QQQ	ETF	30.33	30.65	30.33	30.54	25979585.0
2009-02-04 11:00:00	QQQ	ETF	30.54	30.59	30.39	30.43	14011926.0
2009-02-04 12:00:00	QQQ	ETF	30.43	30.49	30.28	30.2999	12129090.0
2009-02-04 13:00:00	QQQ	ETF	30.29	30.35	29.83	29.97	26319201.0
2009-02-04 14:00:00	QQQ	ETF	29.97	30.06	29.79	30.05	23582927.0
2009-02-04 15:00:00	QQQ	ETF	30.05	30.11	29.86	29.9	27293539.0
2009-02-04 16:00:00	QQQ	ETF	29.91	30.02	29.72	29.73	12703851.0
2009-02-04 17:00:00	QQQ	ETF	29.73	29.77	29.21	29.4	3607939.0
2009-02-04 18:00:00	QQQ	ETF	29.4	29.43	29.32	29.38	211274.0
2009-02-04 19:00:00	QQQ	ETF	29.38	29.38	29.33	29.36	76146.0
2009-02-04 06:00:00	IWM	ETF	44.86	45.04	44.86	45.04	5100.0
2009-02-04 07:00:00	IWM	ETF	44.93	45.15	44.9	45.15	4909.0
2009-02-04 08:00:00	IWM	ETF	45.05	45.45	45.02	45.23	132381.0
2009-02-04 09:00:00	IWM	ETF	45.14	45.63	44.75	45.53	4543896.0
2009-02-04 10:00:00	IWM	ETF	45.53	46.12	45.53	45.99	12456801.0
2009-02-04 11:00:00	IWM	ETF	45.98	46.09	45.68	45.76	4260084.0
2009-02-04 12:00:00	IWM	ETF	45.77	45.86	45.51	45.55	5138088.0
2009-02-04 13:00:00	IWM	ETF	45.56	45.68	44.76	45.0	9904240.0
2009-02-04 14:00:00	IWM	ETF	45.0	45.15	44.53	45.1199	9806563.0
2009-02-04 15:00:00	IWM	ETF	45.11	45.2	44.77	44.81	11066024.0
2009-02-04 16:00:00	IWM	ETF	44.81	45.2362	44.76	44.78	1576454.0
2009-02-04 17:00:00	IWM	ETF	44.78	45.2362	44.47	44.47	1279117.0
2009-02-04 18:00:00	IWM	ETF	44.38	44.47	44.21	44.45	1600.0
2009-02-04 07:00:00	DIA	ETF	80.43	80.54	80.33	80.44	8366.0
2009-02-04 08:00:00	DIA	ETF	80.44	80.92	80.37	80.67	71832.0
2009-02-04 09:00:00	DIA	ETF	80.64	81.14	80.52	81.06	2640667.0
2009-02-04 10:00:00	DIA	ETF	81.06	81.71	81.06	81.41	4835388.0
2009-02-04 11:00:00	DIA	ETF	81.4	81.45	80.94	81.0	2947781.0
2009-02-04 12:00:00	DIA	ETF	81.01	81.16	80.69	80.75	1996288.0

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

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