PREVIEW / etf_30min / 2007-04-12

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-04-12.parquet
  size:    107 KB
  rows:    3,687

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-12 05:00:00	SPY	ETF	143.68	143.68	143.68	143.68	200.0
2007-04-12 06:00:00	SPY	ETF	143.78	143.78	143.78	143.78	5000.0
2007-04-12 06:30:00	SPY	ETF	143.75	143.75	143.74	143.74	20000.0
2007-04-12 07:00:00	SPY	ETF	143.77	143.83	143.75	143.75	18400.0
2007-04-12 07:30:00	SPY	ETF	143.72	143.72	143.55	143.6	213900.0
2007-04-12 08:00:00	SPY	ETF	143.72	143.75	143.62	143.7	156100.0
2007-04-12 08:30:00	SPY	ETF	143.67	143.76	143.59	143.66	648900.0
2007-04-12 09:00:00	SPY	ETF	143.67	143.74	143.66	143.74	318497.0
2007-04-12 09:30:00	SPY	ETF	143.74	143.89	143.34	143.51	17866095.0
2007-04-12 10:00:00	SPY	ETF	143.5	144.07	143.46	143.97	11398192.0
2007-04-12 10:30:00	SPY	ETF	143.97	144.21	143.77	144.09	15303317.0
2007-04-12 11:00:00	SPY	ETF	144.1	144.27	143.96	144.0101	8366719.0
2007-04-12 11:30:00	SPY	ETF	144.01	144.09	143.9	144.08	3593472.0
2007-04-12 12:00:00	SPY	ETF	144.09	144.53	144.05	144.27	11126628.0
2007-04-12 12:30:00	SPY	ETF	144.27	144.31	144.14	144.28	2543261.0
2007-04-12 13:00:00	SPY	ETF	144.29	144.52	144.29	144.51	5971527.0
2007-04-12 13:30:00	SPY	ETF	144.52	144.62	144.46	144.47	7527461.0
2007-04-12 14:00:00	SPY	ETF	144.47	144.59	144.44	144.4594	3396900.0
2007-04-12 14:30:00	SPY	ETF	144.45	144.7	144.43	144.58	8092586.0
2007-04-12 15:00:00	SPY	ETF	144.57	144.69	144.53	144.64	3024146.0
2007-04-12 15:30:00	SPY	ETF	144.64	144.92	144.62	144.74	8429647.0
2007-04-12 16:00:00	SPY	ETF	144.74	144.76	144.121	144.64	4987400.0
2007-04-12 16:30:00	SPY	ETF	144.64	144.67	143.99	143.99	249700.0
2007-04-12 17:00:00	SPY	ETF	144.63	144.65	144.6	144.64	25900.0
2007-04-12 17:30:00	SPY	ETF	144.62	144.68	144.6	144.63	888500.0
2007-04-12 18:30:00	SPY	ETF	144.67	144.67	144.67	144.67	12300.0
2007-04-12 19:00:00	SPY	ETF	144.64	144.67	144.64	144.64	1000.0
2007-04-12 19:30:00	SPY	ETF	144.68	144.72	144.68	144.68	4300.0
2007-04-12 07:00:00	QQQ	ETF	44.13	44.13	44.11	44.11	261700.0
2007-04-12 07:30:00	QQQ	ETF	44.1	44.1	44.04	44.08	483343.0
2007-04-12 08:00:00	QQQ	ETF	44.09	44.13	44.08	44.12	293410.0
2007-04-12 08:30:00	QQQ	ETF	44.11	44.12	44.07	44.09	423296.0
2007-04-12 09:00:00	QQQ	ETF	44.09	44.13	44.08	44.13	571497.0
2007-04-12 09:30:00	QQQ	ETF	44.14	44.19	43.95	44.08	18686800.0
2007-04-12 10:00:00	QQQ	ETF	44.07	44.34	44.07	44.32	16907900.0
2007-04-12 10:30:00	QQQ	ETF	44.32	44.47	44.27	44.42	14291200.0
2007-04-12 11:00:00	QQQ	ETF	44.42	44.48	44.18	44.42	5665900.0
2007-04-12 11:30:00	QQQ	ETF	44.41	44.42	44.32	44.4	3147200.0
2007-04-12 12:00:00	QQQ	ETF	44.4	44.56	44.39	44.49	5867900.0
2007-04-12 12:30:00	QQQ	ETF	44.49	44.52	44.45	44.51	2365000.0
2007-04-12 13:00:00	QQQ	ETF	44.51	44.57	44.5	44.57	4348000.0
2007-04-12 13:30:00	QQQ	ETF	44.57	44.62	44.54	44.55	6596600.0
2007-04-12 14:00:00	QQQ	ETF	44.55	44.56	44.45	44.47	6934800.0
2007-04-12 14:30:00	QQQ	ETF	44.46	44.58	44.44	44.51	4290100.0
2007-04-12 15:00:00	QQQ	ETF	44.5	44.56	44.21	44.54	4650500.0
2007-04-12 15:30:00	QQQ	ETF	44.55	44.61	44.52	44.61	11999400.0
2007-04-12 16:00:00	QQQ	ETF	44.6	44.61	44.5105	44.59	5038798.0
2007-04-12 16:30:00	QQQ	ETF	44.58	44.59	44.52	44.53	270481.0
2007-04-12 17:00:00	QQQ	ETF	44.53	44.55	44.51	44.52	119803.0
2007-04-12 17:30:00	QQQ	ETF	44.52	44.52	44.52	44.52	1000000.0

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

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