PREVIEW / etf_30min / 2007-10-04

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-10-04.parquet
  size:    117 KB
  rows:    4,551

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-10-04 05:30:00	SPY	ETF	154.09	154.09	154.09	154.09	10000.0
2007-10-04 06:00:00	SPY	ETF	154.12	154.12	154.12	154.12	7500.0
2007-10-04 06:30:00	SPY	ETF	154.0	154.13	154.0	154.13	86000.0
2007-10-04 07:00:00	SPY	ETF	154.06	154.09	154.01	154.04	25800.0
2007-10-04 07:30:00	SPY	ETF	154.04	154.17	154.02	154.09	93700.0
2007-10-04 08:00:00	SPY	ETF	154.09	154.13	153.95	154.11	716500.0
2007-10-04 08:30:00	SPY	ETF	154.1	154.23	153.97	154.2	461900.0
2007-10-04 09:00:00	SPY	ETF	154.18	154.22	154.09	154.11	148800.0
2007-10-04 09:30:00	SPY	ETF	154.11	154.16	153.65	153.75	10422710.0
2007-10-04 10:00:00	SPY	ETF	153.76	153.94	153.59	153.79	7475235.0
2007-10-04 10:30:00	SPY	ETF	153.79	154.26	153.75	154.18	9944200.0
2007-10-04 11:00:00	SPY	ETF	154.18	154.22	154.0	154.03	4864500.0
2007-10-04 11:30:00	SPY	ETF	154.03	154.09	153.91	153.95	2205300.0
2007-10-04 12:00:00	SPY	ETF	153.95	154.03	153.84	153.98	3728900.0
2007-10-04 12:30:00	SPY	ETF	153.98	154.1	153.96	154.03	2040900.0
2007-10-04 13:00:00	SPY	ETF	154.04	154.07	153.76	153.98	5584000.0
2007-10-04 13:30:00	SPY	ETF	153.99	154.1	153.89	153.91	3986100.0
2007-10-04 14:00:00	SPY	ETF	153.9	154.02	153.89	153.97	2517500.0
2007-10-04 14:30:00	SPY	ETF	153.97	154.02	153.82	153.9	3578500.0
2007-10-04 15:00:00	SPY	ETF	153.9	153.99	153.85	153.93	4375000.0
2007-10-04 15:30:00	SPY	ETF	153.94	154.19	153.92	154.16	11626200.0
2007-10-04 16:00:00	SPY	ETF	154.14	154.15	153.94	154.02	1105000.0
2007-10-04 16:30:00	SPY	ETF	154.06	154.12	154.0	154.0	471100.0
2007-10-04 17:00:00	SPY	ETF	153.99	154.04	153.99	154.01	8800.0
2007-10-04 17:30:00	SPY	ETF	154.0	154.0	153.9	153.99	28600.0
2007-10-04 18:00:00	SPY	ETF	153.93	153.93	153.87	153.9	46600.0
2007-10-04 18:30:00	SPY	ETF	153.9	153.91	153.86	153.9	2600.0
2007-10-04 19:00:00	SPY	ETF	153.91	153.97	153.87	153.87	11400.0
2007-10-04 19:30:00	SPY	ETF	153.91	153.97	153.91	153.97	87500.0
2007-10-04 05:30:00	QQQ	ETF	51.69	51.69	51.69	51.69	500.0
2007-10-04 07:00:00	QQQ	ETF	51.67	51.67	51.67	51.67	5000.0
2007-10-04 07:30:00	QQQ	ETF	51.67	51.74	51.67	51.68	72604.0
2007-10-04 08:00:00	QQQ	ETF	51.7	51.75	51.66	51.74	638797.0
2007-10-04 08:30:00	QQQ	ETF	51.73	51.78	51.7	51.76	271444.0
2007-10-04 09:00:00	QQQ	ETF	51.73	51.75	51.72	51.74	332900.0
2007-10-04 09:30:00	QQQ	ETF	51.75	51.77	51.34	51.46	18009904.0
2007-10-04 10:00:00	QQQ	ETF	51.46	51.59	51.42	51.53	9431373.0
2007-10-04 10:30:00	QQQ	ETF	51.539	51.8	51.52	51.78	10424313.0
2007-10-04 11:00:00	QQQ	ETF	51.79	51.79	51.7	51.71	5200793.0
2007-10-04 11:30:00	QQQ	ETF	51.71	51.75	51.66	51.6799	2299027.0
2007-10-04 12:00:00	QQQ	ETF	51.67	51.69	51.6	51.6899	2184745.0
2007-10-04 12:30:00	QQQ	ETF	51.69	51.73	51.67	51.7	2540251.0
2007-10-04 13:00:00	QQQ	ETF	51.7	51.71	51.55	51.6581	5104234.0
2007-10-04 13:30:00	QQQ	ETF	51.65	51.68	51.61	51.61	1386484.0
2007-10-04 14:00:00	QQQ	ETF	51.62	51.65	51.6	51.63	1703733.0
2007-10-04 14:30:00	QQQ	ETF	51.63	51.66	51.58	51.63	2475380.0
2007-10-04 15:00:00	QQQ	ETF	51.64	51.73	51.63	51.7	4047735.0
2007-10-04 15:30:00	QQQ	ETF	51.7	51.83	51.7	51.76	9515078.0
2007-10-04 16:00:00	QQQ	ETF	51.76	51.78	51.54	51.71	7507443.0
2007-10-04 16:30:00	QQQ	ETF	51.7	51.7619	51.65	51.66	3242133.0

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

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