PREVIEW / etf_30min / 2009-03-25

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-03-25.parquet
  size:    215 KB
  rows:    7,046

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-25 04:00:00	SPY	ETF	81.0	81.09	81.0	81.09	400.0
2009-03-25 04:30:00	SPY	ETF	81.2	81.24	81.2	81.2	800.0
2009-03-25 05:00:00	SPY	ETF	81.29	81.33	81.28	81.28	550.0
2009-03-25 05:30:00	SPY	ETF	81.29	81.29	81.08	81.08	4200.0
2009-03-25 06:00:00	SPY	ETF	81.11	81.11	81.03	81.06	1400.0
2009-03-25 06:30:00	SPY	ETF	81.04	81.09	80.92	80.96	29550.0
2009-03-25 07:00:00	SPY	ETF	80.93	80.97	80.66	80.83	226428.0
2009-03-25 07:30:00	SPY	ETF	80.87	80.93	80.78	80.93	157553.0
2009-03-25 08:00:00	SPY	ETF	80.93	81.26	80.5959	80.93	3252055.0
2009-03-25 08:30:00	SPY	ETF	80.95	81.28	80.6	81.02	4720578.0
2009-03-25 09:00:00	SPY	ETF	81.01	81.35	80.98	81.22	1687716.0
2009-03-25 09:30:00	SPY	ETF	81.23	81.94	81.13	81.81	37474721.0
2009-03-25 10:00:00	SPY	ETF	81.81	82.61	81.81	82.07	50138986.0
2009-03-25 10:30:00	SPY	ETF	82.07	82.7	82.0	82.06	27897525.0
2009-03-25 11:00:00	SPY	ETF	82.0625	82.44	81.85	82.07	19542423.0
2009-03-25 11:30:00	SPY	ETF	82.07	82.31	81.88	82.1194	18173267.0
2009-03-25 12:00:00	SPY	ETF	82.12	82.51	81.72	81.88	18857121.0
2009-03-25 12:30:00	SPY	ETF	81.89	81.98	81.55	81.73	14600855.0
2009-03-25 13:00:00	SPY	ETF	81.73	81.91	80.88	81.0	21534939.0
2009-03-25 13:30:00	SPY	ETF	81.0	81.1	80.59	80.7575	31674783.0
2009-03-25 14:00:00	SPY	ETF	80.75	80.78	79.86	80.0	37044692.0
2009-03-25 14:30:00	SPY	ETF	80.0	80.07	79.18	79.33	38299003.0
2009-03-25 15:00:00	SPY	ETF	79.33	82.47	79.06	80.08	34706506.0
2009-03-25 15:30:00	SPY	ETF	80.08	81.57	79.5	81.34	64274502.0
2009-03-25 16:00:00	SPY	ETF	81.35	82.7	80.48	81.21	9752058.0
2009-03-25 16:30:00	SPY	ETF	81.21	81.46	81.13	81.45	1372250.0
2009-03-25 17:00:00	SPY	ETF	81.45	81.66	81.4	81.6	1875021.0
2009-03-25 17:30:00	SPY	ETF	81.61	81.62	81.55	81.59	1084104.0
2009-03-25 18:00:00	SPY	ETF	81.55	81.55	81.47	81.54	45481.0
2009-03-25 18:30:00	SPY	ETF	81.57	81.58	81.54	81.58	10947.0
2009-03-25 19:00:00	SPY	ETF	81.56	81.6	81.54	81.57	42127.0
2009-03-25 19:30:00	SPY	ETF	81.57	81.58	81.45	81.5	162613.0
2009-03-25 05:30:00	QQQ	ETF	30.53	30.53	30.53	30.53	100.0
2009-03-25 06:00:00	QQQ	ETF	30.51	30.54	30.51	30.54	200.0
2009-03-25 06:30:00	QQQ	ETF	30.52	30.52	30.52	30.52	200.0
2009-03-25 07:00:00	QQQ	ETF	30.45	30.48	30.42	30.47	101163.0
2009-03-25 07:30:00	QQQ	ETF	30.49	30.52	30.41	30.45	251956.0
2009-03-25 08:00:00	QQQ	ETF	30.45	30.6	30.4	30.46	890552.0
2009-03-25 08:30:00	QQQ	ETF	30.47	30.6	30.47	30.54	1226043.0
2009-03-25 09:00:00	QQQ	ETF	30.54	30.65	30.52	30.58	691799.0
2009-03-25 09:30:00	QQQ	ETF	30.58	30.8388	30.57	30.81	20979008.0
2009-03-25 10:00:00	QQQ	ETF	30.81	31.05	30.8	30.811	18884906.0
2009-03-25 10:30:00	QQQ	ETF	30.819	31.01	30.78	30.8105	12647838.0
2009-03-25 11:00:00	QQQ	ETF	30.8171	30.93	30.67	30.76	7768067.0
2009-03-25 11:30:00	QQQ	ETF	30.76	30.82	30.68	30.75	6612680.0
2009-03-25 12:00:00	QQQ	ETF	30.75	30.87	30.55	30.61	8404966.0
2009-03-25 12:30:00	QQQ	ETF	30.61	30.64	30.46	30.55	6103655.0
2009-03-25 13:00:00	QQQ	ETF	30.55	30.61	30.17	30.249	10793683.0
2009-03-25 13:30:00	QQQ	ETF	30.25	30.31	30.1	30.18	13201463.0
2009-03-25 14:00:00	QQQ	ETF	30.19	30.19	29.87	29.95	14487830.0

> showing 50 of 7,046 rows — these rows as CSV

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