PREVIEW / etf_30min / 2007-07-05

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-07-05.parquet
  size:    118 KB
  rows:    4,526

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-07-05 04:30:00	SPY	ETF	152.49	152.49	152.49	152.49	100.0
2007-07-05 06:30:00	SPY	ETF	152.64	152.64	152.52	152.52	4500.0
2007-07-05 07:00:00	SPY	ETF	152.46	152.52	152.39	152.52	72100.0
2007-07-05 07:30:00	SPY	ETF	152.54	152.72	152.54	152.68	198700.0
2007-07-05 08:00:00	SPY	ETF	152.68	152.76	152.22	152.71	396800.0
2007-07-05 08:30:00	SPY	ETF	152.68	152.72	152.31	152.32	1281200.0
2007-07-05 09:00:00	SPY	ETF	152.54	152.54	152.29	152.43	1871650.0
2007-07-05 09:30:00	SPY	ETF	152.43	152.5	152.11	152.38	7800473.0
2007-07-05 10:00:00	SPY	ETF	152.38	152.56	152.25	152.35	8910328.0
2007-07-05 10:30:00	SPY	ETF	152.35	152.54	152.08	152.23	7111853.0
2007-07-05 11:00:00	SPY	ETF	152.23	152.32	151.93	152.19	7174302.0
2007-07-05 11:30:00	SPY	ETF	152.19	152.29	151.98	152.06	3875663.0
2007-07-05 12:00:00	SPY	ETF	152.05	152.19	151.81	151.81	6272027.0
2007-07-05 12:30:00	SPY	ETF	151.81	151.85	151.63	151.77	10911792.0
2007-07-05 13:00:00	SPY	ETF	151.77	151.99	151.73	151.95	2656434.0
2007-07-05 13:30:00	SPY	ETF	151.95	152.13	151.86	151.9	4373344.0
2007-07-05 14:00:00	SPY	ETF	151.89	152.24	151.84	152.2	3957539.0
2007-07-05 14:30:00	SPY	ETF	152.2	152.35	152.18	152.29	4018175.0
2007-07-05 15:00:00	SPY	ETF	152.3	152.32	152.16	152.31	3874800.0
2007-07-05 15:30:00	SPY	ETF	152.3	152.53	152.22	152.43	6174358.0
2007-07-05 16:00:00	SPY	ETF	152.42	152.44	151.85	152.21	4890200.0
2007-07-05 16:30:00	SPY	ETF	152.21	152.36	152.18	152.18	85000.0
2007-07-05 17:00:00	SPY	ETF	152.19	152.25	152.19	152.22	30800.0
2007-07-05 17:30:00	SPY	ETF	152.2	152.2	152.2	152.2	300.0
2007-07-05 18:00:00	SPY	ETF	152.22	152.39	152.22	152.32	112000.0
2007-07-05 18:30:00	SPY	ETF	152.18	152.39	152.18	152.39	102900.0
2007-07-05 19:00:00	SPY	ETF	152.34	152.34	152.34	152.34	4300.0
2007-07-05 19:30:00	SPY	ETF	152.3	152.34	152.3	152.34	10000.0
2007-07-05 04:00:00	QQQ	ETF	48.33	48.33	48.33	48.33	1000.0
2007-07-05 04:30:00	QQQ	ETF	48.34	48.35	48.34	48.35	28044.0
2007-07-05 07:00:00	QQQ	ETF	48.31	48.33	48.3	48.33	50000.0
2007-07-05 07:30:00	QQQ	ETF	48.37	48.45	48.37	48.43	401589.0
2007-07-05 08:00:00	QQQ	ETF	48.44	48.47	48.41	48.44	845275.0
2007-07-05 08:30:00	QQQ	ETF	48.44	48.45	48.36	48.38	1142801.0
2007-07-05 09:00:00	QQQ	ETF	48.38	48.42	48.33	48.35	678068.0
2007-07-05 09:30:00	QQQ	ETF	48.35	48.45	48.29	48.43	5879861.0
2007-07-05 10:00:00	QQQ	ETF	48.422	48.46	48.39	48.43	4447426.0
2007-07-05 10:30:00	QQQ	ETF	48.44	48.52	48.4	48.4699	5711789.0
2007-07-05 11:00:00	QQQ	ETF	48.47	48.47	48.3	48.43	5466624.0
2007-07-05 11:30:00	QQQ	ETF	48.43	48.4601	48.37	48.4	3858306.0
2007-07-05 12:00:00	QQQ	ETF	48.4	48.44	48.33	48.3389	4541782.0
2007-07-05 12:30:00	QQQ	ETF	48.34	48.4	48.29	48.37	5274552.0
2007-07-05 13:00:00	QQQ	ETF	48.37	48.45	48.36	48.43	2480347.0
2007-07-05 13:30:00	QQQ	ETF	48.43	48.48	48.42	48.44	2150378.0
2007-07-05 14:00:00	QQQ	ETF	48.435	48.57	48.43	48.55	3649550.0
2007-07-05 14:30:00	QQQ	ETF	48.55	48.65	48.55	48.63	4417089.0
2007-07-05 15:00:00	QQQ	ETF	48.64	48.65	48.59	48.64	2986949.0
2007-07-05 15:30:00	QQQ	ETF	48.64	48.77	48.61	48.71	12679629.0
2007-07-05 16:00:00	QQQ	ETF	48.7	48.71	48.6	48.63	3335833.0
2007-07-05 16:30:00	QQQ	ETF	48.63	48.66	48.61	48.62	355954.0

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

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