PREVIEW / etf_30min / 2007-04-24

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-04-24.parquet
  size:    108 KB
  rows:    3,784

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-24 06:00:00	SPY	ETF	148.05	148.13	148.04	148.09	21900.0
2007-04-24 06:30:00	SPY	ETF	148.11	148.2	148.11	148.2	8000.0
2007-04-24 07:00:00	SPY	ETF	148.17	148.3	148.17	148.3	17200.0
2007-04-24 07:30:00	SPY	ETF	148.28	148.38	148.28	148.36	173000.0
2007-04-24 08:00:00	SPY	ETF	148.18	148.4	148.02	148.26	558500.0
2007-04-24 08:30:00	SPY	ETF	148.26	148.27	148.14	148.17	438000.0
2007-04-24 09:00:00	SPY	ETF	148.17	148.35	148.15	148.23	716700.0
2007-04-24 09:30:00	SPY	ETF	148.23	148.29	147.85	148.04	8436634.0
2007-04-24 10:00:00	SPY	ETF	148.03	148.04	147.38	147.48	21774777.0
2007-04-24 10:30:00	SPY	ETF	147.48	147.65	147.32	147.51	10773987.0
2007-04-24 11:00:00	SPY	ETF	147.51	147.78	147.43	147.78	8929854.0
2007-04-24 11:30:00	SPY	ETF	147.78	147.89	147.72	147.82	5696673.0
2007-04-24 12:00:00	SPY	ETF	147.82	148.24	147.76	148.15	9742169.0
2007-04-24 12:30:00	SPY	ETF	148.16	148.16	147.89	147.98	4024698.0
2007-04-24 13:00:00	SPY	ETF	147.98	148.02	147.74	147.87	5418957.0
2007-04-24 13:30:00	SPY	ETF	147.87	148.11	147.74	148.07	6866618.0
2007-04-24 14:00:00	SPY	ETF	148.07	148.4	148.01	148.25	8809738.0
2007-04-24 14:30:00	SPY	ETF	148.25	148.3	148.04	148.13	4506250.0
2007-04-24 15:00:00	SPY	ETF	148.13	148.24	148.1	148.14	3682425.0
2007-04-24 15:30:00	SPY	ETF	148.14	148.23	147.92	148.04	8060017.0
2007-04-24 16:00:00	SPY	ETF	148.06	148.21	147.99	148.15	1437100.0
2007-04-24 16:30:00	SPY	ETF	148.14	148.17	147.83	148.15	3088600.0
2007-04-24 17:00:00	SPY	ETF	148.17	148.18	148.1	148.15	467200.0
2007-04-24 17:30:00	SPY	ETF	148.16	148.16	148.16	148.16	200.0
2007-04-24 18:30:00	SPY	ETF	148.19	148.29	148.19	148.25	3000.0
2007-04-24 19:00:00	SPY	ETF	148.24	148.24	148.24	148.24	100.0
2007-04-24 19:30:00	SPY	ETF	148.23	148.27	148.23	148.27	1000.0
2007-04-24 04:30:00	QQQ	ETF	45.5	45.5	45.5	45.5	50000.0
2007-04-24 06:30:00	QQQ	ETF	45.58	45.58	45.58	45.58	30200.0
2007-04-24 07:00:00	QQQ	ETF	45.57	45.67	45.57	45.65	245573.0
2007-04-24 07:30:00	QQQ	ETF	45.64	45.67	45.64	45.67	60217.0
2007-04-24 08:00:00	QQQ	ETF	45.68	45.7	45.62	45.63	198854.0
2007-04-24 08:30:00	QQQ	ETF	45.64	45.65	45.61	45.63	56261.0
2007-04-24 09:00:00	QQQ	ETF	45.63	45.68	45.63	45.63	720015.0
2007-04-24 09:30:00	QQQ	ETF	45.63	45.64	45.52	45.58	12509700.0
2007-04-24 10:00:00	QQQ	ETF	45.58	45.58	45.34	45.42	17071200.0
2007-04-24 10:30:00	QQQ	ETF	45.41	45.5	45.33	45.43	9306900.0
2007-04-24 11:00:00	QQQ	ETF	45.43	45.53	45.41	45.53	5897100.0
2007-04-24 11:30:00	QQQ	ETF	45.53	45.59	45.53	45.54	5740200.0
2007-04-24 12:00:00	QQQ	ETF	45.55	45.81	45.53	45.77	12082500.0
2007-04-24 12:30:00	QQQ	ETF	45.77	45.8	45.7	45.73	5779900.0
2007-04-24 13:00:00	QQQ	ETF	45.73	45.74	45.59	45.63	6145800.0
2007-04-24 13:30:00	QQQ	ETF	45.63	45.78	45.63	45.75	4678800.0
2007-04-24 14:00:00	QQQ	ETF	45.76	45.83	45.71	45.79	6657300.0
2007-04-24 14:30:00	QQQ	ETF	45.79	45.8	45.49	45.73	5723300.0
2007-04-24 15:00:00	QQQ	ETF	45.74	45.78	45.72	45.73	3212000.0
2007-04-24 15:30:00	QQQ	ETF	45.72	45.75	45.64	45.7	9633600.0
2007-04-24 16:00:00	QQQ	ETF	45.69	45.73	45.67	45.7	2014215.0
2007-04-24 16:30:00	QQQ	ETF	45.68	45.7	45.66	45.68	175827.0
2007-04-24 17:00:00	QQQ	ETF	45.7	45.71	45.7	45.71	51831.0

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

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