PREVIEW / etf_1hour / 2009-03-11

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-03-11.parquet
  size:    128 KB
  rows:    3,942

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-11 04:00:00	SPY	ETF	72.04	72.26	71.93	72.01	5979.0
2009-03-11 05:00:00	SPY	ETF	72.29	72.91	72.26	72.91	15317.0
2009-03-11 06:00:00	SPY	ETF	72.81	73.51	72.81	73.0	318284.0
2009-03-11 07:00:00	SPY	ETF	73.02	73.3	72.79	72.83	1075336.0
2009-03-11 08:00:00	SPY	ETF	72.82	73.25	71.8	73.02	3166335.0
2009-03-11 09:00:00	SPY	ETF	73.02	73.75	72.31	73.51	52130091.0
2009-03-11 10:00:00	SPY	ETF	73.51	73.64	72.96	73.2	59893629.0
2009-03-11 11:00:00	SPY	ETF	73.21	73.42	72.59	72.95	45071898.0
2009-03-11 12:00:00	SPY	ETF	72.96	73.06	72.2	72.2	32311552.0
2009-03-11 13:00:00	SPY	ETF	72.21	72.86	72.18	72.6301	39161332.0
2009-03-11 14:00:00	SPY	ETF	72.64	72.82	71.83	72.38	48736998.0
2009-03-11 15:00:00	SPY	ETF	72.37	73.32	72.36	72.6	56626053.0
2009-03-11 16:00:00	SPY	ETF	72.6	73.25	72.11	72.58	11272641.0
2009-03-11 17:00:00	SPY	ETF	72.57	72.67	72.57	72.6	193104.0
2009-03-11 18:00:00	SPY	ETF	72.6	72.67	72.59	72.66	55740.0
2009-03-11 19:00:00	SPY	ETF	72.62	72.62	72.19	72.19	115946.0
2009-03-11 05:00:00	QQQ	ETF	27.26	27.54	27.26	27.54	521.0
2009-03-11 06:00:00	QQQ	ETF	27.55	27.73	27.55	27.57	7900.0
2009-03-11 07:00:00	QQQ	ETF	27.57	27.68	27.52	27.59	403258.0
2009-03-11 08:00:00	QQQ	ETF	27.59	27.68	27.52	27.64	1199003.0
2009-03-11 09:00:00	QQQ	ETF	27.62	27.86	27.26	27.84	27432900.0
2009-03-11 10:00:00	QQQ	ETF	27.83	27.99	27.68	27.87	28090248.0
2009-03-11 11:00:00	QQQ	ETF	27.87	27.93	27.61	27.72	20896338.0
2009-03-11 12:00:00	QQQ	ETF	27.72	27.75	27.5	27.502	14588974.0
2009-03-11 13:00:00	QQQ	ETF	27.51	27.81	27.51	27.75	19854914.0
2009-03-11 14:00:00	QQQ	ETF	27.75	27.81	27.46	27.63	25730358.0
2009-03-11 15:00:00	QQQ	ETF	27.645	27.98	27.63	27.729	25100001.0
2009-03-11 16:00:00	QQQ	ETF	27.73	27.9452	27.4117	27.7	4640128.0
2009-03-11 17:00:00	QQQ	ETF	27.71	27.72	27.67	27.7	47486.0
2009-03-11 18:00:00	QQQ	ETF	27.71	27.72	27.7	27.72	20508.0
2009-03-11 19:00:00	QQQ	ETF	27.72	27.72	27.6	27.62	34058.0
2009-03-11 06:00:00	IWM	ETF	36.99	37.09	36.99	36.99	5300.0
2009-03-11 07:00:00	IWM	ETF	36.96	37.13	36.95	36.95	8000.0
2009-03-11 08:00:00	IWM	ETF	36.96	37.15	36.85	37.04	226000.0
2009-03-11 09:00:00	IWM	ETF	37.03	37.8	36.62	37.74	15989253.0
2009-03-11 10:00:00	IWM	ETF	37.74	37.77	37.17	37.24	9283198.0
2009-03-11 11:00:00	IWM	ETF	37.24	37.33	36.9	37.06	6522133.0
2009-03-11 12:00:00	IWM	ETF	37.06	37.15	36.69	36.699	4778523.0
2009-03-11 13:00:00	IWM	ETF	36.69	36.91	36.65	36.79	5638640.0
2009-03-11 14:00:00	IWM	ETF	36.8	36.88	36.36	36.56	12991989.0
2009-03-11 15:00:00	IWM	ETF	36.56	37.11	36.4	36.68	14216542.0
2009-03-11 16:00:00	IWM	ETF	36.69	36.8299	36.4	36.6	6610175.0
2009-03-11 17:00:00	IWM	ETF	36.61	36.76	36.6	36.76	15980.0
2009-03-11 18:00:00	IWM	ETF	36.65	36.69	36.52	36.52	900.0
2009-03-11 19:00:00	IWM	ETF	36.69	36.69	36.69	36.69	300.0
2009-03-11 04:00:00	DIA	ETF	68.9	68.9	68.9	68.9	200.0
2009-03-11 05:00:00	DIA	ETF	69.31	69.44	69.31	69.44	400.0
2009-03-11 06:00:00	DIA	ETF	69.75	70.13	69.71	69.71	17693.0
2009-03-11 07:00:00	DIA	ETF	69.67	69.93	69.58	69.58	16609.0
2009-03-11 08:00:00	DIA	ETF	69.52	69.77	69.45	69.66	45925.0

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

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