PREVIEW / etf_30min / 2007-09-27

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-09-27.parquet
  size:    123 KB
  rows:    4,740

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-09-27 04:00:00	SPY	ETF	152.97	152.99	152.97	152.99	700.0
2007-09-27 04:30:00	SPY	ETF	152.85	152.85	152.85	152.85	2000.0
2007-09-27 06:00:00	SPY	ETF	152.85	152.85	152.85	152.85	2000.0
2007-09-27 06:30:00	SPY	ETF	152.85	152.85	152.79	152.82	4500.0
2007-09-27 07:00:00	SPY	ETF	152.84	152.84	152.5	152.6	73400.0
2007-09-27 07:30:00	SPY	ETF	152.58	152.75	152.57	152.65	289300.0
2007-09-27 08:00:00	SPY	ETF	152.63	152.73	152.51	152.67	1082500.0
2007-09-27 08:30:00	SPY	ETF	152.65	152.88	152.6	152.86	1363900.0
2007-09-27 09:00:00	SPY	ETF	152.86	152.98	152.86	152.89	922643.0
2007-09-27 09:30:00	SPY	ETF	152.88	152.98	152.59	152.64	10567131.0
2007-09-27 10:00:00	SPY	ETF	152.64	152.88	152.42	152.63	13183300.0
2007-09-27 10:30:00	SPY	ETF	152.64	152.92	152.56	152.84	13063600.0
2007-09-27 11:00:00	SPY	ETF	152.85	152.89	152.37	152.43	5750600.0
2007-09-27 11:30:00	SPY	ETF	152.43	152.62	152.35	152.5	4572700.0
2007-09-27 12:00:00	SPY	ETF	152.501	152.7	152.4	152.56	2632300.0
2007-09-27 12:30:00	SPY	ETF	152.56	152.69	152.54	152.59	2840600.0
2007-09-27 13:00:00	SPY	ETF	152.6	152.79	152.55	152.67	3962900.0
2007-09-27 13:30:00	SPY	ETF	152.68	152.7	152.46	152.64	4374800.0
2007-09-27 14:00:00	SPY	ETF	152.63	152.96	152.6	152.89	6634800.0
2007-09-27 14:30:00	SPY	ETF	152.9	152.94	152.53	152.73	5416400.0
2007-09-27 15:00:00	SPY	ETF	152.74	153.08	152.73	152.99	8767300.0
2007-09-27 15:30:00	SPY	ETF	153.0	153.0	152.8	152.95	9007600.0
2007-09-27 16:00:00	SPY	ETF	152.96	153.31	152.35	153.12	4834500.0
2007-09-27 16:30:00	SPY	ETF	153.1	153.1	152.91	152.96	1628200.0
2007-09-27 17:00:00	SPY	ETF	152.92	153.01	152.9	153.01	61700.0
2007-09-27 17:30:00	SPY	ETF	153.02	153.09	152.97	152.97	93100.0
2007-09-27 18:00:00	SPY	ETF	152.97	152.99	152.94	152.99	1100.0
2007-09-27 18:30:00	SPY	ETF	152.95	152.95	152.92	152.92	12100.0
2007-09-27 19:00:00	SPY	ETF	152.95	152.95	152.92	152.92	1500.0
2007-09-27 19:30:00	SPY	ETF	152.95	152.97	152.94	152.97	3000.0
2007-09-27 07:00:00	QQQ	ETF	51.39	51.58	51.36	51.51	223534.0
2007-09-27 07:30:00	QQQ	ETF	51.49	51.56	51.48	51.56	31874.0
2007-09-27 08:00:00	QQQ	ETF	51.52	51.55	51.5	51.55	314361.0
2007-09-27 08:30:00	QQQ	ETF	51.55	51.62	51.5	51.62	984300.0
2007-09-27 09:00:00	QQQ	ETF	51.62	51.65	51.58	51.63	799443.0
2007-09-27 09:30:00	QQQ	ETF	51.63	51.65	51.44	51.46	11855541.0
2007-09-27 10:00:00	QQQ	ETF	51.45	51.52	51.36	51.4115	10135199.0
2007-09-27 10:30:00	QQQ	ETF	51.4199	51.62	51.41	51.6	5800373.0
2007-09-27 11:00:00	QQQ	ETF	51.5987	51.6	51.41	51.43	4098705.0
2007-09-27 11:30:00	QQQ	ETF	51.42	51.5	51.41	51.4425	3376162.0
2007-09-27 12:00:00	QQQ	ETF	51.4475	51.53	51.43	51.5	3254256.0
2007-09-27 12:30:00	QQQ	ETF	51.5	51.54	51.49	51.5	2457233.0
2007-09-27 13:00:00	QQQ	ETF	51.5	51.57	51.48	51.52	3209229.0
2007-09-27 13:30:00	QQQ	ETF	51.52	51.53	51.41	51.47	3081936.0
2007-09-27 14:00:00	QQQ	ETF	51.47	51.59	51.47	51.58	4599860.0
2007-09-27 14:30:00	QQQ	ETF	51.58	51.6	51.47	51.5	4272432.0
2007-09-27 15:00:00	QQQ	ETF	51.5	51.58	51.47	51.55	4504821.0
2007-09-27 15:30:00	QQQ	ETF	51.55	51.56	51.48	51.52	7587724.0
2007-09-27 16:00:00	QQQ	ETF	51.53	51.65	51.385	51.61	2401843.0
2007-09-27 16:30:00	QQQ	ETF	51.59	51.59	51.55	51.57	69772.0

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

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