PREVIEW / etf_30min / 2008-04-28

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-04-28.parquet
  size:    154 KB
  rows:    5,548

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-04-28 04:30:00	SPY	ETF	139.69	139.73	139.69	139.73	600.0
2008-04-28 06:00:00	SPY	ETF	140.0	140.2	140.0	140.13	40500.0
2008-04-28 06:30:00	SPY	ETF	140.14	140.31	140.14	140.24	41139.0
2008-04-28 07:00:00	SPY	ETF	140.15	140.25	140.1	140.1	217200.0
2008-04-28 07:30:00	SPY	ETF	140.02	140.1	139.95	139.96	144125.0
2008-04-28 08:00:00	SPY	ETF	139.98	140.28	139.88	139.95	668999.0
2008-04-28 08:30:00	SPY	ETF	139.95	140.13	139.67	139.74	1038327.0
2008-04-28 09:00:00	SPY	ETF	139.75	139.9	139.66	139.87	1565834.0
2008-04-28 09:30:00	SPY	ETF	139.88	139.99	139.38	139.7101	14237453.0
2008-04-28 10:00:00	SPY	ETF	139.72	139.99	139.48	139.86	11145366.0
2008-04-28 10:30:00	SPY	ETF	139.85	140.13	139.79	140.01	11311259.0
2008-04-28 11:00:00	SPY	ETF	140.0	140.05	139.56	139.708	6391958.0
2008-04-28 11:30:00	SPY	ETF	139.71	139.93	139.64	139.8001	3638394.0
2008-04-28 12:00:00	SPY	ETF	139.8	140.07	139.77	140.07	4430177.0
2008-04-28 12:30:00	SPY	ETF	140.07	140.16	139.89	139.91	3838758.0
2008-04-28 13:00:00	SPY	ETF	139.92	140.11	139.9	140.04	4642341.0
2008-04-28 13:30:00	SPY	ETF	140.04	140.21	140.02	140.19	6326566.0
2008-04-28 14:00:00	SPY	ETF	140.185	140.24	139.96	139.98	5776465.0
2008-04-28 14:30:00	SPY	ETF	139.98	140.21	139.9	140.05	5111785.0
2008-04-28 15:00:00	SPY	ETF	140.06	140.25	139.82	139.85	6699217.0
2008-04-28 15:30:00	SPY	ETF	139.86	139.9	139.41	139.62	12671657.0
2008-04-28 16:00:00	SPY	ETF	139.64	139.8009	139.35	139.63	3125534.0
2008-04-28 16:30:00	SPY	ETF	139.63	139.7	139.57	139.66	206730.0
2008-04-28 17:00:00	SPY	ETF	139.65	139.68	139.54	139.66	188307.0
2008-04-28 17:30:00	SPY	ETF	139.56	139.59	139.45	139.59	15779.0
2008-04-28 18:00:00	SPY	ETF	139.6	139.67	139.57	139.67	19466.0
2008-04-28 18:30:00	SPY	ETF	139.7	139.71	139.7	139.7	2760.0
2008-04-28 19:00:00	SPY	ETF	139.7	139.72	139.67	139.67	3377.0
2008-04-28 19:30:00	SPY	ETF	139.72	139.72	139.66	139.71	4570.0
2008-04-28 06:00:00	QQQ	ETF	47.32	47.32	47.32	47.32	2100.0
2008-04-28 06:30:00	QQQ	ETF	47.32	47.36	47.31	47.31	13400.0
2008-04-28 07:00:00	QQQ	ETF	47.31	47.32	47.3	47.3	6700.0
2008-04-28 07:30:00	QQQ	ETF	47.25	47.28	47.23	47.26	51300.0
2008-04-28 08:00:00	QQQ	ETF	47.24	47.28	47.18	47.24	205721.0
2008-04-28 08:30:00	QQQ	ETF	47.24	47.29	47.2	47.24	487487.0
2008-04-28 09:00:00	QQQ	ETF	47.24	47.27	47.23	47.25	119952.0
2008-04-28 09:30:00	QQQ	ETF	47.25	47.34	47.13	47.31	7802308.0
2008-04-28 10:00:00	QQQ	ETF	47.31	47.46	47.22	47.32	7640901.0
2008-04-28 10:30:00	QQQ	ETF	47.33	47.46	47.32	47.46	5118093.0
2008-04-28 11:00:00	QQQ	ETF	47.45	47.47	47.27	47.33	4654486.0
2008-04-28 11:30:00	QQQ	ETF	47.33	47.46	47.3	47.36	2217510.0
2008-04-28 12:00:00	QQQ	ETF	47.3575	47.46	47.34	47.45	2891223.0
2008-04-28 12:30:00	QQQ	ETF	47.45	47.48	47.4	47.42	2298421.0
2008-04-28 13:00:00	QQQ	ETF	47.43	47.54	47.42	47.53	3689931.0
2008-04-28 13:30:00	QQQ	ETF	47.54	47.61	47.54	47.59	3433936.0
2008-04-28 14:00:00	QQQ	ETF	47.59	47.62	47.49	47.49	3314795.0
2008-04-28 14:30:00	QQQ	ETF	47.49	47.56	47.43	47.49	3962231.0
2008-04-28 15:00:00	QQQ	ETF	47.49	47.6	47.37	47.3875	4144328.0
2008-04-28 15:30:00	QQQ	ETF	47.39	47.6	47.23	47.26	9311447.0
2008-04-28 16:00:00	QQQ	ETF	47.26	47.4107	47.14	47.26	8606072.0

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

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