PREVIEW / etf_1hour / 2009-03-27

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-03-27.parquet
  size:    130 KB
  rows:    4,064

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-27 04:00:00	SPY	ETF	82.64	82.82	82.64	82.82	700.0
2009-03-27 05:00:00	SPY	ETF	82.8	82.89	82.51	82.51	8587.0
2009-03-27 06:00:00	SPY	ETF	82.62	82.62	82.32	82.35	160373.0
2009-03-27 07:00:00	SPY	ETF	82.4	82.67	82.22	82.22	728267.0
2009-03-27 08:00:00	SPY	ETF	82.23	83.11	81.96	82.19	4125372.0
2009-03-27 09:00:00	SPY	ETF	82.2	82.7	81.7	81.98	33498085.0
2009-03-27 10:00:00	SPY	ETF	81.99	82.31	81.5	82.13	41584075.0
2009-03-27 11:00:00	SPY	ETF	82.13	82.5	81.96	82.269	37473775.0
2009-03-27 12:00:00	SPY	ETF	82.25	82.53	81.8	81.86	37840349.0
2009-03-27 13:00:00	SPY	ETF	81.85	82.23	81.31	81.51	41471008.0
2009-03-27 14:00:00	SPY	ETF	81.51	82.05	81.32	81.99	41096202.0
2009-03-27 15:00:00	SPY	ETF	81.99	82.37	81.35	81.62	67021210.0
2009-03-27 16:00:00	SPY	ETF	81.6	83.2806	81.58	82.12	11379134.0
2009-03-27 17:00:00	SPY	ETF	82.13	83.2806	82.01	82.07	5155002.0
2009-03-27 18:00:00	SPY	ETF	82.08	82.11	82.03	82.04	63357.0
2009-03-27 19:00:00	SPY	ETF	82.05	82.08	81.99	82.02	31590.0
2009-03-27 04:00:00	QQQ	ETF	31.23	31.23	31.19	31.19	2057.0
2009-03-27 05:00:00	QQQ	ETF	31.13	31.13	31.11	31.11	400.0
2009-03-27 06:00:00	QQQ	ETF	31.14	31.14	31.06	31.06	3797.0
2009-03-27 07:00:00	QQQ	ETF	31.1	31.19	30.99	30.99	470386.0
2009-03-27 08:00:00	QQQ	ETF	30.99	31.12	30.9	30.94	2789809.0
2009-03-27 09:00:00	QQQ	ETF	30.94	31.15	30.89	30.99	18107177.0
2009-03-27 10:00:00	QQQ	ETF	30.999	31.12	30.84	31.05	18252611.0
2009-03-27 11:00:00	QQQ	ETF	31.06	31.18	30.91	31.098	16012111.0
2009-03-27 12:00:00	QQQ	ETF	31.09	31.18	30.87	30.89	17091701.0
2009-03-27 13:00:00	QQQ	ETF	30.88	30.96	30.71	30.77	26688356.0
2009-03-27 14:00:00	QQQ	ETF	30.78	30.96	30.74	30.9	16886344.0
2009-03-27 15:00:00	QQQ	ETF	30.9	31.06	30.72	30.79	24648038.0
2009-03-27 16:00:00	QQQ	ETF	30.78	31.5148	30.72	30.97	4635295.0
2009-03-27 17:00:00	QQQ	ETF	30.97	30.98	30.87	30.87	42466.0
2009-03-27 18:00:00	QQQ	ETF	30.9	30.92	30.89	30.9	35725.0
2009-03-27 19:00:00	QQQ	ETF	30.92	30.93	30.88	30.92	16021.0
2009-03-27 05:00:00	IWM	ETF	44.0	44.0	44.0	44.0	200.0
2009-03-27 06:00:00	IWM	ETF	43.9	43.9	43.8	43.8	2873.0
2009-03-27 07:00:00	IWM	ETF	43.9	43.95	43.75	43.75	37974.0
2009-03-27 08:00:00	IWM	ETF	43.76	43.9	43.6	43.7	404399.0
2009-03-27 09:00:00	IWM	ETF	43.7	43.87	43.42	43.54	7477718.0
2009-03-27 10:00:00	IWM	ETF	43.54	43.91	43.38	43.74	7109710.0
2009-03-27 11:00:00	IWM	ETF	43.74	44.0	43.63	43.8492	5763015.0
2009-03-27 12:00:00	IWM	ETF	43.84	44.0	43.31	43.34	11689091.0
2009-03-27 13:00:00	IWM	ETF	43.34	43.58	42.97	43.031	10860798.0
2009-03-27 14:00:00	IWM	ETF	43.05	43.51	42.98	43.44	6984673.0
2009-03-27 15:00:00	IWM	ETF	43.44	43.8	42.83	42.9	16371218.0
2009-03-27 16:00:00	IWM	ETF	42.9	44.4984	42.86	43.13	2863446.0
2009-03-27 17:00:00	IWM	ETF	43.05	44.4984	43.03	43.04	1501195.0
2009-03-27 19:00:00	IWM	ETF	43.08	43.08	43.05	43.05	2980.0
2009-03-27 06:00:00	DIA	ETF	78.53	78.53	78.4	78.42	1048.0
2009-03-27 07:00:00	DIA	ETF	78.44	78.6	78.26	78.26	13290.0
2009-03-27 08:00:00	DIA	ETF	78.26	78.45	78.09	78.28	85048.0
2009-03-27 09:00:00	DIA	ETF	78.28	78.29	77.9	78.07	2393603.0

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

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