PREVIEW / etf_30min / 2008-06-19

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-06-19.parquet
  size:    166 KB
  rows:    5,706

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-06-19 04:00:00	SPY	ETF	133.96	133.96	133.96	133.96	1000.0
2008-06-19 04:30:00	SPY	ETF	134.3	134.3	134.22	134.22	1100.0
2008-06-19 05:00:00	SPY	ETF	134.29	134.29	134.29	134.29	100.0
2008-06-19 05:30:00	SPY	ETF	134.31	134.32	134.22	134.22	1500.0
2008-06-19 06:00:00	SPY	ETF	134.23	134.27	134.23	134.27	3500.0
2008-06-19 06:30:00	SPY	ETF	134.24	134.24	134.24	134.24	3000.0
2008-06-19 07:00:00	SPY	ETF	134.24	134.41	134.2	134.39	202694.0
2008-06-19 07:30:00	SPY	ETF	134.39	134.58	134.38	134.55	446614.0
2008-06-19 08:00:00	SPY	ETF	134.54	134.6	134.26	134.44	1432133.0
2008-06-19 08:30:00	SPY	ETF	134.43	134.63	134.23	134.29	2587526.0
2008-06-19 09:00:00	SPY	ETF	134.3	134.33	134.12	134.15	1399702.0
2008-06-19 09:30:00	SPY	ETF	134.15	134.67	133.85	134.11	26254789.0
2008-06-19 10:00:00	SPY	ETF	134.12	134.31	133.55	134.05	31938169.0
2008-06-19 10:30:00	SPY	ETF	134.05	134.45	133.85	134.36	17831377.0
2008-06-19 11:00:00	SPY	ETF	134.36	134.58	133.5	133.78	29558996.0
2008-06-19 11:30:00	SPY	ETF	133.78	133.95	133.66	133.82	15597494.0
2008-06-19 12:00:00	SPY	ETF	133.82	134.57	133.75	134.27	29114440.0
2008-06-19 12:30:00	SPY	ETF	134.28	134.55	134.13	134.22	17050973.0
2008-06-19 13:00:00	SPY	ETF	134.21	134.47	134.05	134.461	9269417.0
2008-06-19 13:30:00	SPY	ETF	134.46	134.59	133.99	134.2	19778073.0
2008-06-19 14:00:00	SPY	ETF	134.2	134.66	133.97	134.52	17866014.0
2008-06-19 14:30:00	SPY	ETF	134.52	135.04	134.3462	134.96	22158277.0
2008-06-19 15:00:00	SPY	ETF	134.95	135.24	134.8	134.86	23169616.0
2008-06-19 15:30:00	SPY	ETF	134.85	135.05	134.63	134.72	30106519.0
2008-06-19 16:00:00	SPY	ETF	134.68	134.69	134.25	134.5	3323749.0
2008-06-19 16:30:00	SPY	ETF	134.48	134.55	134.25	134.52	1771439.0
2008-06-19 17:00:00	SPY	ETF	134.54	134.61	134.54	134.55	45583.0
2008-06-19 17:30:00	SPY	ETF	134.55	134.56	134.52	134.54	7000.0
2008-06-19 18:00:00	SPY	ETF	134.56	134.56	134.39	134.43	64350.0
2008-06-19 18:30:00	SPY	ETF	134.44	134.44	134.43	134.43	300.0
2008-06-19 19:00:00	SPY	ETF	134.43	134.43	134.29	134.3	14800.0
2008-06-19 19:30:00	SPY	ETF	134.28	134.28	134.12	134.2	20075.0
2008-06-19 07:00:00	QQQ	ETF	47.97	48.05	47.97	48.05	106300.0
2008-06-19 07:30:00	QQQ	ETF	48.05	48.08	48.03	48.08	35778.0
2008-06-19 08:00:00	QQQ	ETF	48.07	48.1	48.03	48.05	250087.0
2008-06-19 08:30:00	QQQ	ETF	48.04	48.12	47.93	47.95	954934.0
2008-06-19 09:00:00	QQQ	ETF	47.96	47.96	47.88	47.91	1134450.0
2008-06-19 09:30:00	QQQ	ETF	47.91	48.17	47.85	48.0	14630927.0
2008-06-19 10:00:00	QQQ	ETF	48.0	48.03	47.61	47.83	23323305.0
2008-06-19 10:30:00	QQQ	ETF	47.84	48.17	47.82	48.12	15402451.0
2008-06-19 11:00:00	QQQ	ETF	48.12	48.27	47.84	47.98	17097282.0
2008-06-19 11:30:00	QQQ	ETF	47.9801	48.19	47.95	48.15	9493663.0
2008-06-19 12:00:00	QQQ	ETF	48.15	48.67	48.12	48.52	24936398.0
2008-06-19 12:30:00	QQQ	ETF	48.53	48.66	48.41	48.4422	12624714.0
2008-06-19 13:00:00	QQQ	ETF	48.44	48.6	48.41	48.58	6767366.0
2008-06-19 13:30:00	QQQ	ETF	48.57	48.65	48.38	48.49	5767054.0
2008-06-19 14:00:00	QQQ	ETF	48.49	48.67	48.39	48.62	8417990.0
2008-06-19 14:30:00	QQQ	ETF	48.62	49.0	48.61	48.9	21336549.0
2008-06-19 15:00:00	QQQ	ETF	48.9	49.01	48.78	48.81	13798582.0
2008-06-19 15:30:00	QQQ	ETF	48.81	48.84	48.71	48.79	14189101.0

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

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