PREVIEW / etf_30min / 2008-04-29

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-04-29.parquet
  size:    161 KB
  rows:    5,634

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-29 04:00:00	SPY	ETF	139.57	139.57	139.57	139.57	300.0
2008-04-29 05:00:00	SPY	ETF	139.43	139.43	139.41	139.41	200.0
2008-04-29 05:30:00	SPY	ETF	139.42	139.42	139.37	139.41	300.0
2008-04-29 06:00:00	SPY	ETF	139.3	139.35	139.22	139.35	150200.0
2008-04-29 06:30:00	SPY	ETF	139.31	139.4	139.28	139.35	77000.0
2008-04-29 07:00:00	SPY	ETF	139.34	139.48	139.25	139.47	368300.0
2008-04-29 07:30:00	SPY	ETF	139.41	139.5	139.3	139.3	198905.0
2008-04-29 08:00:00	SPY	ETF	139.31	139.58	139.26	139.53	1745753.0
2008-04-29 08:30:00	SPY	ETF	139.53	139.62	139.41	139.47	455522.0
2008-04-29 09:00:00	SPY	ETF	139.47	139.49	139.34	139.4	866267.0
2008-04-29 09:30:00	SPY	ETF	139.39	139.73	139.22	139.31	15836831.0
2008-04-29 10:00:00	SPY	ETF	139.31	139.55	138.76	138.83	13197563.0
2008-04-29 10:30:00	SPY	ETF	138.82	138.95	138.61	138.77	9853338.0
2008-04-29 11:00:00	SPY	ETF	138.77	139.04	138.67	139.005	7544162.0
2008-04-29 11:30:00	SPY	ETF	139.0	139.07	138.81	138.88	7273139.0
2008-04-29 12:00:00	SPY	ETF	138.88	139.597	138.77	139.1	6217577.0
2008-04-29 12:30:00	SPY	ETF	139.1	139.19	138.97	139.0	7255772.0
2008-04-29 13:00:00	SPY	ETF	139.0	139.3	138.94	139.2	6546828.0
2008-04-29 13:30:00	SPY	ETF	139.19	139.41	139.14	139.25	9287774.0
2008-04-29 14:00:00	SPY	ETF	139.25	139.3953	139.05	139.27	5624511.0
2008-04-29 14:30:00	SPY	ETF	139.26	139.59	139.14	139.55	9144604.0
2008-04-29 15:00:00	SPY	ETF	139.55	139.61	139.17	139.188	8956119.0
2008-04-29 15:30:00	SPY	ETF	139.18	139.32	138.97	139.07	10617289.0
2008-04-29 16:00:00	SPY	ETF	139.12	139.3	138.72	138.78	2483215.0
2008-04-29 16:30:00	SPY	ETF	138.78	139.06	138.68	138.87	401360.0
2008-04-29 17:00:00	SPY	ETF	138.85	138.88	138.8	138.88	121007.0
2008-04-29 17:30:00	SPY	ETF	138.88	138.88	138.85	138.85	626.0
2008-04-29 18:00:00	SPY	ETF	138.84	138.88	138.84	138.87	7991.0
2008-04-29 18:30:00	SPY	ETF	138.89	139.01	138.89	139.01	23546.0
2008-04-29 19:00:00	SPY	ETF	138.94	138.95	138.94	138.95	5000.0
2008-04-29 19:30:00	SPY	ETF	138.9	139.0	138.9	138.95	7165.0
2008-04-29 04:00:00	QQQ	ETF	47.24	47.24	47.24	47.24	1000.0
2008-04-29 05:30:00	QQQ	ETF	47.15	47.15	47.15	47.15	200.0
2008-04-29 06:00:00	QQQ	ETF	47.13	47.13	47.07	47.07	550.0
2008-04-29 06:30:00	QQQ	ETF	47.11	47.11	47.1	47.1	400.0
2008-04-29 07:00:00	QQQ	ETF	47.1	47.12	47.09	47.12	35364.0
2008-04-29 07:30:00	QQQ	ETF	47.15	47.16	47.11	47.11	44700.0
2008-04-29 08:00:00	QQQ	ETF	47.12	47.19	47.1	47.18	402377.0
2008-04-29 08:30:00	QQQ	ETF	47.18	47.2	47.14	47.15	268797.0
2008-04-29 09:00:00	QQQ	ETF	47.14	47.15	47.11	47.14	589479.0
2008-04-29 09:30:00	QQQ	ETF	47.14	47.35	47.12	47.32	10289067.0
2008-04-29 10:00:00	QQQ	ETF	47.32	47.39	47.06	47.09	12902941.0
2008-04-29 10:30:00	QQQ	ETF	47.089	47.24	47.071	47.19	5334366.0
2008-04-29 11:00:00	QQQ	ETF	47.19	47.38	47.16	47.3695	4245414.0
2008-04-29 11:30:00	QQQ	ETF	47.36	47.3696	47.25	47.27	2225744.0
2008-04-29 12:00:00	QQQ	ETF	47.28	47.34	47.18	47.32	4892530.0
2008-04-29 12:30:00	QQQ	ETF	47.32	47.358	47.26	47.27	3665537.0
2008-04-29 13:00:00	QQQ	ETF	47.27	47.49	47.25	47.47	4774106.0
2008-04-29 13:30:00	QQQ	ETF	47.48	47.57	47.41	47.45	4847591.0
2008-04-29 14:00:00	QQQ	ETF	47.44	47.59	47.32	47.54	5090343.0

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

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