PREVIEW / etf_30min / 2007-08-07

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-08-07.parquet
  size:    129 KB
  rows:    4,705

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-07 06:00:00	SPY	ETF	146.47	146.47	146.47	146.47	7500.0
2007-08-07 07:00:00	SPY	ETF	146.32	146.33	146.12	146.12	154000.0
2007-08-07 07:30:00	SPY	ETF	146.16	146.48	146.16	146.42	372000.0
2007-08-07 08:00:00	SPY	ETF	146.4	146.5	146.39	146.39	711800.0
2007-08-07 08:30:00	SPY	ETF	146.4	146.4	145.92	146.02	2610900.0
2007-08-07 09:00:00	SPY	ETF	146.02	146.09	145.84	145.95	3369100.0
2007-08-07 09:30:00	SPY	ETF	145.94	146.4	145.23	146.4	21468080.0
2007-08-07 10:00:00	SPY	ETF	146.39	146.85	146.34	146.51	17114928.0
2007-08-07 10:30:00	SPY	ETF	146.51	146.57	146.2	146.45	8492365.0
2007-08-07 11:00:00	SPY	ETF	146.46	146.65	146.34	146.63	5841718.0
2007-08-07 11:30:00	SPY	ETF	146.64	147.21	146.55	147.13	13874757.0
2007-08-07 12:00:00	SPY	ETF	147.13	147.53	147.08	147.25	8965196.0
2007-08-07 12:30:00	SPY	ETF	147.25	147.49	147.04	147.09	8052512.0
2007-08-07 13:00:00	SPY	ETF	147.08	147.5	147.06	147.41	7009462.0
2007-08-07 13:30:00	SPY	ETF	147.41	147.73	147.25	147.54	9626421.0
2007-08-07 14:00:00	SPY	ETF	147.54	147.81	145.93	146.11	46895071.0
2007-08-07 14:30:00	SPY	ETF	146.12	147.8	145.6	147.7	42097022.0
2007-08-07 15:00:00	SPY	ETF	147.7	148.84	147.52	148.06	35133563.0
2007-08-07 15:30:00	SPY	ETF	148.06	149.0	147.36	147.68	33370804.0
2007-08-07 16:00:00	SPY	ETF	147.69	148.69	145.8318	147.8	6373700.0
2007-08-07 16:30:00	SPY	ETF	147.77	148.15	146.75	148.12	1718400.0
2007-08-07 17:00:00	SPY	ETF	148.07	148.11	148.0	148.01	267000.0
2007-08-07 17:30:00	SPY	ETF	148.01	148.1	148.0	148.08	13900.0
2007-08-07 18:00:00	SPY	ETF	148.02	148.02	145.8318	147.88	381700.0
2007-08-07 18:30:00	SPY	ETF	147.89	147.92	147.88	147.92	3200.0
2007-08-07 19:00:00	SPY	ETF	147.93	147.93	147.93	147.93	500.0
2007-08-07 19:30:00	SPY	ETF	147.87	147.87	147.81	147.81	14700.0
2007-08-07 04:00:00	QQQ	ETF	47.94	47.94	47.94	47.94	200.0
2007-08-07 07:00:00	QQQ	ETF	47.91	47.92	47.88	47.89	50100.0
2007-08-07 07:30:00	QQQ	ETF	47.9	47.99	47.88	47.98	129061.0
2007-08-07 08:00:00	QQQ	ETF	47.99	48.06	47.99	48.04	1002231.0
2007-08-07 08:30:00	QQQ	ETF	48.03	48.03	47.82	47.85	3328986.0
2007-08-07 09:00:00	QQQ	ETF	47.86	47.89	47.82	47.88	734117.0
2007-08-07 09:30:00	QQQ	ETF	47.88	48.0	47.72	47.96	10927559.0
2007-08-07 10:00:00	QQQ	ETF	47.96	48.07	47.89	47.92	7924429.0
2007-08-07 10:30:00	QQQ	ETF	47.91	47.93	47.8	47.89	6564716.0
2007-08-07 11:00:00	QQQ	ETF	47.89	47.93	47.82	47.9	4359235.0
2007-08-07 11:30:00	QQQ	ETF	47.9	48.02	47.82	47.93	5353055.0
2007-08-07 12:00:00	QQQ	ETF	47.93	48.06	47.89	47.95	6619510.0
2007-08-07 12:30:00	QQQ	ETF	47.95	48.01	47.9	47.9	2908196.0
2007-08-07 13:00:00	QQQ	ETF	47.9	48.03	47.89	47.996	3133397.0
2007-08-07 13:30:00	QQQ	ETF	47.99	48.08	47.955	48.0	6036141.0
2007-08-07 14:00:00	QQQ	ETF	48.01	48.12	47.6	47.64	28330351.0
2007-08-07 14:30:00	QQQ	ETF	47.64	48.08	47.48	48.08	24874956.0
2007-08-07 15:00:00	QQQ	ETF	48.07	48.29	48.07	48.27	12687053.0
2007-08-07 15:30:00	QQQ	ETF	48.2774	48.62	48.0485	48.17	25678028.0
2007-08-07 16:00:00	QQQ	ETF	48.17	48.33	48.11	48.17	2303349.0
2007-08-07 16:30:00	QQQ	ETF	48.18	48.59	47.57	48.54	2845154.0
2007-08-07 17:00:00	QQQ	ETF	48.53	48.56	48.47	48.49	415203.0
2007-08-07 17:30:00	QQQ	ETF	48.5	48.55	48.48	48.49	48435.0

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

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