PREVIEW / etf_30min / 2007-04-19

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-04-19.parquet
  size:    109 KB
  rows:    3,822

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
2007-04-19 04:00:00	SPY	ETF	146.18	146.23	146.18	146.19	36100.0
2007-04-19 04:30:00	SPY	ETF	146.26	146.26	146.26	146.26	1000.0
2007-04-19 05:30:00	SPY	ETF	146.38	146.4	146.38	146.4	7200.0
2007-04-19 06:00:00	SPY	ETF	146.35	146.36	146.34	146.36	10100.0
2007-04-19 06:30:00	SPY	ETF	146.46	146.55	146.46	146.55	15700.0
2007-04-19 07:00:00	SPY	ETF	146.52	146.53	146.4	146.45	141700.0
2007-04-19 07:30:00	SPY	ETF	146.42	146.45	146.35	146.43	344400.0
2007-04-19 08:00:00	SPY	ETF	146.55	146.64	146.05	146.61	1700700.0
2007-04-19 08:30:00	SPY	ETF	146.61	146.61	146.42	146.52	1547600.0
2007-04-19 09:00:00	SPY	ETF	146.51	146.57	146.45	146.54	1101200.0
2007-04-19 09:30:00	SPY	ETF	146.55	146.83	146.36	146.71	16136022.0
2007-04-19 10:00:00	SPY	ETF	146.71	147.07	146.61	146.97	11819832.0
2007-04-19 10:30:00	SPY	ETF	146.98	147.04	146.53	146.89	8067696.0
2007-04-19 11:00:00	SPY	ETF	146.9	147.14	146.75	146.98	6344801.0
2007-04-19 11:30:00	SPY	ETF	146.97	147.2	146.79	147.13	5992395.0
2007-04-19 12:00:00	SPY	ETF	147.13	147.34	146.99	147.24	7494756.0
2007-04-19 12:30:00	SPY	ETF	147.24	147.39	147.14	147.32	6030824.0
2007-04-19 13:00:00	SPY	ETF	147.33	147.4	147.3	147.35	3015271.0
2007-04-19 13:30:00	SPY	ETF	147.36	147.37	147.21	147.32	2791558.0
2007-04-19 14:00:00	SPY	ETF	147.31	147.32	146.98	147.07	6768026.0
2007-04-19 14:30:00	SPY	ETF	147.07	147.16	146.95	147.06	4072514.0
2007-04-19 15:00:00	SPY	ETF	147.07	147.21	147.02	147.19	3722856.0
2007-04-19 15:30:00	SPY	ETF	147.19	147.21	146.88	147.03	11183685.0
2007-04-19 16:00:00	SPY	ETF	147.03	147.33	147.01	147.25	1612000.0
2007-04-19 16:30:00	SPY	ETF	147.25	147.33	146.73	147.24	1381300.0
2007-04-19 17:00:00	SPY	ETF	147.31	147.35	147.29	147.32	19300.0
2007-04-19 17:30:00	SPY	ETF	147.34	147.35	147.05	147.28	386200.0
2007-04-19 18:00:00	SPY	ETF	147.28	147.33	147.28	147.28	12500.0
2007-04-19 18:30:00	SPY	ETF	147.26	147.27	147.26	147.27	400.0
2007-04-19 19:00:00	SPY	ETF	146.95	147.31	146.95	147.31	21900.0
2007-04-19 19:30:00	SPY	ETF	147.29	147.35	147.29	147.35	1300.0
2007-04-19 04:00:00	QQQ	ETF	44.76	44.77	44.76	44.77	51445.0
2007-04-19 04:30:00	QQQ	ETF	44.77	44.77	44.77	44.77	67145.0
2007-04-19 05:30:00	QQQ	ETF	44.78	44.78	44.78	44.78	100.0
2007-04-19 06:00:00	QQQ	ETF	44.79	44.79	44.79	44.79	1000.0
2007-04-19 06:30:00	QQQ	ETF	44.84	44.85	44.83	44.85	40400.0
2007-04-19 07:00:00	QQQ	ETF	44.86	44.86	44.79	44.82	375411.0
2007-04-19 07:30:00	QQQ	ETF	44.81	44.85	44.79	44.81	409108.0
2007-04-19 08:00:00	QQQ	ETF	44.8	44.89	44.8	44.87	1087154.0
2007-04-19 08:30:00	QQQ	ETF	44.86	44.89	44.82	44.86	978264.0
2007-04-19 09:00:00	QQQ	ETF	44.85	44.86	44.8	44.82	1107724.0
2007-04-19 09:30:00	QQQ	ETF	44.81	44.94	44.72	44.9	13711700.0
2007-04-19 10:00:00	QQQ	ETF	44.9	45.07	44.86	44.99	12139900.0
2007-04-19 10:30:00	QQQ	ETF	44.98	45.0	44.9	44.99	6255800.0
2007-04-19 11:00:00	QQQ	ETF	44.99	45.14	44.95	45.06	7470400.0
2007-04-19 11:30:00	QQQ	ETF	45.06	45.16	45.02	45.12	4879400.0
2007-04-19 12:00:00	QQQ	ETF	45.13	45.2	44.98	45.18	7891700.0
2007-04-19 12:30:00	QQQ	ETF	45.18	45.22	45.11	45.19	4084500.0
2007-04-19 13:00:00	QQQ	ETF	45.2	45.25	45.18	45.2	2895900.0
2007-04-19 13:30:00	QQQ	ETF	45.19	45.21	45.13	45.15	3429500.0

> showing 50 of 3,822 rows — these rows as CSV

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