PREVIEW / etf_30min / 2007-11-19

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-11-19.parquet
  size:    148 KB
  rows:    5,343

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-11-19 04:00:00	SPY	ETF	145.93	145.93	145.93	145.93	1000.0
2007-11-19 04:30:00	SPY	ETF	145.53	145.53	145.53	145.53	1000.0
2007-11-19 05:30:00	SPY	ETF	145.43	145.43	145.37	145.37	20100.0
2007-11-19 06:00:00	SPY	ETF	145.1	145.35	144.93	144.93	32900.0
2007-11-19 06:30:00	SPY	ETF	145.05	145.17	145.05	145.15	41000.0
2007-11-19 07:00:00	SPY	ETF	145.15	145.34	145.09	145.18	827400.0
2007-11-19 07:30:00	SPY	ETF	145.18	145.46	145.1	145.32	209800.0
2007-11-19 08:00:00	SPY	ETF	145.3	145.3	145.0	145.14	1019800.0
2007-11-19 08:30:00	SPY	ETF	145.15	145.25	145.04	145.17	388000.0
2007-11-19 09:00:00	SPY	ETF	145.15	145.31	145.02	145.27	796009.0
2007-11-19 09:30:00	SPY	ETF	145.28	145.36	144.56	144.88	22316807.0
2007-11-19 10:00:00	SPY	ETF	144.88	145.14	144.58	144.8	18237499.0
2007-11-19 10:30:00	SPY	ETF	144.8	144.8	144.02	144.09	28392150.0
2007-11-19 11:00:00	SPY	ETF	144.1	144.19	143.63	143.83	27782617.0
2007-11-19 11:30:00	SPY	ETF	143.83	144.23	143.78	143.81	16327302.0
2007-11-19 12:00:00	SPY	ETF	143.82	145.155	143.73	144.27	10836658.0
2007-11-19 12:30:00	SPY	ETF	144.27	144.3	143.67	143.85	9372627.0
2007-11-19 13:00:00	SPY	ETF	143.85	144.06	143.21	143.72	20063763.0
2007-11-19 13:30:00	SPY	ETF	143.72	144.117	143.19	143.33	9583976.0
2007-11-19 14:00:00	SPY	ETF	143.3	144.29	143.26	144.23	25075620.0
2007-11-19 14:30:00	SPY	ETF	144.24	144.61	143.96	144.04	15907314.0
2007-11-19 15:00:00	SPY	ETF	144.04	144.33	143.57	144.07	21323925.0
2007-11-19 15:30:00	SPY	ETF	144.07	144.2	143.37	143.54	23068073.0
2007-11-19 16:00:00	SPY	ETF	143.54	146.0818	143.51	143.74	3310700.0
2007-11-19 16:30:00	SPY	ETF	143.74	143.77	143.53	143.69	582100.0
2007-11-19 17:00:00	SPY	ETF	146.0818	146.0818	143.45	143.65	2506900.0
2007-11-19 17:30:00	SPY	ETF	143.65	145.29	143.63	143.78	734200.0
2007-11-19 18:00:00	SPY	ETF	143.78	143.97	143.72	143.95	86200.0
2007-11-19 18:30:00	SPY	ETF	143.94	144.06	143.94	144.0	11900.0
2007-11-19 19:00:00	SPY	ETF	144.06	144.09	144.03	144.04	14300.0
2007-11-19 19:30:00	SPY	ETF	144.01	144.07	143.92	144.05	14600.0
2007-11-19 05:30:00	QQQ	ETF	50.27	50.27	50.19	50.19	30100.0
2007-11-19 06:00:00	QQQ	ETF	50.07	50.08	50.07	50.08	200.0
2007-11-19 06:30:00	QQQ	ETF	50.1	50.11	50.1	50.11	200.0
2007-11-19 07:00:00	QQQ	ETF	50.12	50.17	50.1	50.11	95700.0
2007-11-19 07:30:00	QQQ	ETF	50.12	50.26	50.11	50.21	215452.0
2007-11-19 08:00:00	QQQ	ETF	50.22	50.23	50.05	50.11	914602.0
2007-11-19 08:30:00	QQQ	ETF	50.11	50.2	50.11	50.17	975304.0
2007-11-19 09:00:00	QQQ	ETF	50.17	50.19	50.12	50.17	958842.0
2007-11-19 09:30:00	QQQ	ETF	50.16	50.45	50.0	50.26	20502174.0
2007-11-19 10:00:00	QQQ	ETF	50.2524	50.38	50.12	50.22	13369260.0
2007-11-19 10:30:00	QQQ	ETF	50.22	50.22	49.86	49.91	10713232.0
2007-11-19 11:00:00	QQQ	ETF	49.92	49.9785	49.65	49.75	15866781.0
2007-11-19 11:30:00	QQQ	ETF	49.74	50.0	49.74	49.8	11650468.0
2007-11-19 12:00:00	QQQ	ETF	49.79	50.0001	49.74	49.96	6995576.0
2007-11-19 12:30:00	QQQ	ETF	49.95	49.9701	49.66	49.725	7969398.0
2007-11-19 13:00:00	QQQ	ETF	49.73	49.83	49.52	49.72	13437030.0
2007-11-19 13:30:00	QQQ	ETF	49.7199	49.77	49.44	49.49	9245351.0
2007-11-19 14:00:00	QQQ	ETF	49.49	49.98	49.41	49.92	14958924.0
2007-11-19 14:30:00	QQQ	ETF	49.93	50.16	49.84	49.87	14750418.0

> showing 50 of 5,343 rows — these rows as CSV

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