PREVIEW / etf_30min / 2007-08-22

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-08-22.parquet
  size:    126 KB
  rows:    4,794

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-08-22 04:00:00	SPY	ETF	145.79	146.08	145.79	146.03	6200.0
2007-08-22 04:30:00	SPY	ETF	145.98	145.98	145.96	145.96	600.0
2007-08-22 06:30:00	SPY	ETF	146.03	146.12	146.01	146.05	25400.0
2007-08-22 07:00:00	SPY	ETF	146.0	146.06	145.85	145.88	261800.0
2007-08-22 07:30:00	SPY	ETF	145.92	145.95	145.75	145.83	506400.0
2007-08-22 08:00:00	SPY	ETF	145.83	146.125	145.79	145.9	1158500.0
2007-08-22 08:30:00	SPY	ETF	145.88	146.04	145.78	145.99	515800.0
2007-08-22 09:00:00	SPY	ETF	146.0	146.1	145.87	146.0	1183100.0
2007-08-22 09:30:00	SPY	ETF	146.01	146.6	146.01	146.29	23971224.0
2007-08-22 10:00:00	SPY	ETF	146.29	146.45	146.1	146.29	13350400.0
2007-08-22 10:30:00	SPY	ETF	146.29	146.53	146.14	146.25	8575700.0
2007-08-22 11:00:00	SPY	ETF	146.25	146.35	145.77	145.97	15877500.0
2007-08-22 11:30:00	SPY	ETF	145.98	146.31	145.91	146.12	7787700.0
2007-08-22 12:00:00	SPY	ETF	146.11	146.39	145.81	145.9	9223200.0
2007-08-22 12:30:00	SPY	ETF	145.91	146.2	145.42	145.72	14131800.0
2007-08-22 13:00:00	SPY	ETF	145.72	145.85	145.33	145.7	11028600.0
2007-08-22 13:30:00	SPY	ETF	145.69	146.21	145.66	146.14	8012448.0
2007-08-22 14:00:00	SPY	ETF	146.12	146.18	145.63	145.65	6241700.0
2007-08-22 14:30:00	SPY	ETF	145.65	146.11	145.5	146.0	7138800.0
2007-08-22 15:00:00	SPY	ETF	146.0	146.49	145.84	146.31	10007400.0
2007-08-22 15:30:00	SPY	ETF	146.3	146.8	146.3	146.66	19505800.0
2007-08-22 16:00:00	SPY	ETF	146.69	146.8	146.48	146.7	2775900.0
2007-08-22 16:30:00	SPY	ETF	146.7	146.75	146.61	146.73	857500.0
2007-08-22 17:00:00	SPY	ETF	146.73	146.81	144.9721	146.75	3583400.0
2007-08-22 17:30:00	SPY	ETF	146.79	147.15	146.79	147.15	423400.0
2007-08-22 18:00:00	SPY	ETF	147.15	147.85	146.96	147.72	1698800.0
2007-08-22 18:30:00	SPY	ETF	147.72	147.88	146.78	147.73	1172100.0
2007-08-22 19:00:00	SPY	ETF	147.73	147.8	147.58	147.7	101700.0
2007-08-22 19:30:00	SPY	ETF	147.72	147.84	147.67	147.82	130500.0
2007-08-22 04:00:00	QQQ	ETF	47.24	47.28	47.24	47.28	400.0
2007-08-22 05:00:00	QQQ	ETF	47.2	47.2	47.2	47.2	100.0
2007-08-22 05:30:00	QQQ	ETF	47.25	47.25	47.25	47.25	25000.0
2007-08-22 06:00:00	QQQ	ETF	47.25	47.25	47.2	47.25	45100.0
2007-08-22 06:30:00	QQQ	ETF	47.29	47.34	47.29	47.34	35000.0
2007-08-22 07:00:00	QQQ	ETF	47.27	47.27	47.2	47.24	179000.0
2007-08-22 07:30:00	QQQ	ETF	47.23	47.27	47.19	47.24	332356.0
2007-08-22 08:00:00	QQQ	ETF	47.24	47.33	47.23	47.27	768917.0
2007-08-22 08:30:00	QQQ	ETF	47.27	47.33	47.25	47.31	293226.0
2007-08-22 09:00:00	QQQ	ETF	47.32	47.39	47.3	47.37	1989275.0
2007-08-22 09:30:00	QQQ	ETF	47.375	47.57	47.35	47.49	20318511.0
2007-08-22 10:00:00	QQQ	ETF	47.49	47.52	47.4	47.48	6891957.0
2007-08-22 10:30:00	QQQ	ETF	47.48	47.55	47.44	47.4619	6227807.0
2007-08-22 11:00:00	QQQ	ETF	47.47	47.51	47.362	47.44	6416754.0
2007-08-22 11:30:00	QQQ	ETF	47.43	47.5	47.39	47.4799	3452314.0
2007-08-22 12:00:00	QQQ	ETF	47.47	47.52	47.37	47.41	3697124.0
2007-08-22 12:30:00	QQQ	ETF	47.4094	47.42	47.28	47.36	7831812.0
2007-08-22 13:00:00	QQQ	ETF	47.35	47.41	47.27	47.39	6991333.0
2007-08-22 13:30:00	QQQ	ETF	47.4	47.52	47.38	47.49	5614173.0
2007-08-22 14:00:00	QQQ	ETF	47.49	47.53	47.37	47.38	5553240.0
2007-08-22 14:30:00	QQQ	ETF	47.38	47.53	47.33	47.486	7380758.0

> showing 50 of 4,794 rows — these rows as CSV

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