PREVIEW / etf_30min / 2008-03-31

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-03-31.parquet
  size:    153 KB
  rows:    5,528

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
2008-03-31 04:00:00	SPY	ETF	130.76	130.82	130.76	130.82	3700.0
2008-03-31 04:30:00	SPY	ETF	130.79	130.79	130.79	130.79	100.0
2008-03-31 05:30:00	SPY	ETF	131.1	131.1	131.1	131.1	500.0
2008-03-31 06:00:00	SPY	ETF	131.2	131.44	131.2	131.44	12700.0
2008-03-31 06:30:00	SPY	ETF	131.35	131.54	131.3	131.42	43500.0
2008-03-31 07:00:00	SPY	ETF	131.48	131.6	131.3	131.46	72200.0
2008-03-31 07:30:00	SPY	ETF	131.5	131.7	131.46	131.69	131500.0
2008-03-31 08:00:00	SPY	ETF	131.69	131.79	130.68	131.51	1152300.0
2008-03-31 08:30:00	SPY	ETF	131.5	131.56	131.19	131.28	957900.0
2008-03-31 09:00:00	SPY	ETF	131.31	131.44	131.1	131.29	639600.0
2008-03-31 09:30:00	SPY	ETF	131.29	132.05	131.09	131.89	22890041.0
2008-03-31 10:00:00	SPY	ETF	131.88	131.92	131.37	131.48	12283931.0
2008-03-31 10:30:00	SPY	ETF	131.48	131.89	131.36	131.85	8368383.0
2008-03-31 11:00:00	SPY	ETF	131.85	132.12	131.62	132.01	9372126.0
2008-03-31 11:30:00	SPY	ETF	132.02	132.35	131.99	132.21	6884985.0
2008-03-31 12:00:00	SPY	ETF	132.2	132.3	131.91	132.08	5123946.0
2008-03-31 12:30:00	SPY	ETF	132.07	132.42	131.96	132.415	4974820.0
2008-03-31 13:00:00	SPY	ETF	132.4	132.62	132.36	132.57	7945801.0
2008-03-31 13:30:00	SPY	ETF	132.57	132.73	132.34	132.36	7358472.0
2008-03-31 14:00:00	SPY	ETF	132.35	132.37	132.1	132.27	8425231.0
2008-03-31 14:30:00	SPY	ETF	132.26	132.44	131.78	132.05	8938871.0
2008-03-31 15:00:00	SPY	ETF	132.04	132.28	131.83	132.01	10367262.0
2008-03-31 15:30:00	SPY	ETF	132.0	132.57	131.89	131.94	23961731.0
2008-03-31 16:00:00	SPY	ETF	131.96	132.5047	131.14	131.87	14914800.0
2008-03-31 16:30:00	SPY	ETF	131.89	132.06	131.75	132.0	813900.0
2008-03-31 17:00:00	SPY	ETF	132.0	132.0	131.92	131.93	241100.0
2008-03-31 17:30:00	SPY	ETF	131.93	132.03	131.9	131.95	155400.0
2008-03-31 18:00:00	SPY	ETF	131.95	131.95	131.82	131.88	88600.0
2008-03-31 18:30:00	SPY	ETF	131.87	132.0	131.83	132.0	53200.0
2008-03-31 19:00:00	SPY	ETF	132.03	132.03	131.99	132.01	11300.0
2008-03-31 19:30:00	SPY	ETF	132.0	132.0	131.86	131.86	12400.0
2008-03-31 04:00:00	QQQ	ETF	43.41	43.41	43.41	43.41	2000.0
2008-03-31 05:00:00	QQQ	ETF	43.49	43.49	43.49	43.49	2000.0
2008-03-31 05:30:00	QQQ	ETF	43.53	43.53	43.53	43.53	1000.0
2008-03-31 06:00:00	QQQ	ETF	43.61	43.61	43.61	43.61	2700.0
2008-03-31 07:00:00	QQQ	ETF	43.67	43.67	43.63	43.63	53100.0
2008-03-31 07:30:00	QQQ	ETF	43.63	43.8	43.63	43.8	251257.0
2008-03-31 08:00:00	QQQ	ETF	43.79	43.8	43.37	43.72	1630370.0
2008-03-31 08:30:00	QQQ	ETF	43.72	43.74	43.59	43.65	476894.0
2008-03-31 09:00:00	QQQ	ETF	43.64	43.69	43.6	43.65	886648.0
2008-03-31 09:30:00	QQQ	ETF	43.65	43.95	43.55	43.9	19777706.0
2008-03-31 10:00:00	QQQ	ETF	43.9	43.9	43.5	43.5399	10532198.0
2008-03-31 10:30:00	QQQ	ETF	43.53	43.68	43.45	43.65	10834673.0
2008-03-31 11:00:00	QQQ	ETF	43.65	43.72	43.54	43.7	4795814.0
2008-03-31 11:30:00	QQQ	ETF	43.7	43.86	43.69	43.75	6101428.0
2008-03-31 12:00:00	QQQ	ETF	43.75	43.8	43.63	43.692	4542187.0
2008-03-31 12:30:00	QQQ	ETF	43.69	43.87	43.68	43.8501	3220439.0
2008-03-31 13:00:00	QQQ	ETF	43.85	43.95	43.83	43.94	4916574.0
2008-03-31 13:30:00	QQQ	ETF	43.9401	44.02	43.87	43.8999	4203442.0
2008-03-31 14:00:00	QQQ	ETF	43.89	43.9	43.78	43.87	4799418.0

> showing 50 of 5,528 rows — these rows as CSV

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