PREVIEW / etf_30min / 2007-08-10

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-08-10.parquet
  size:    135 KB
  rows:    4,922

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-10 04:00:00	SPY	ETF	144.85	144.85	144.85	144.85	3700.0
2007-08-10 04:30:00	SPY	ETF	145.25	145.4	145.22	145.4	4600.0
2007-08-10 05:00:00	SPY	ETF	145.15	145.15	145.02	145.02	1200.0
2007-08-10 05:30:00	SPY	ETF	144.71	144.71	144.71	144.71	1000.0
2007-08-10 06:00:00	SPY	ETF	144.51	144.61	144.2	144.5	22300.0
2007-08-10 06:30:00	SPY	ETF	144.44	144.44	144.0	144.08	198300.0
2007-08-10 07:00:00	SPY	ETF	144.11	144.13	143.53	143.62	1991500.0
2007-08-10 07:30:00	SPY	ETF	143.65	144.01	142.93	143.0	2632900.0
2007-08-10 08:00:00	SPY	ETF	143.0	144.87	142.96	143.86	7244000.0
2007-08-10 08:30:00	SPY	ETF	143.85	145.0	143.49	143.91	7075900.0
2007-08-10 09:00:00	SPY	ETF	143.93	150.2046	143.74	144.23	7755080.0
2007-08-10 09:30:00	SPY	ETF	144.24	144.48	143.3	144.26	42387773.0
2007-08-10 10:00:00	SPY	ETF	144.26	144.5	143.44	143.6	33278361.0
2007-08-10 10:30:00	SPY	ETF	143.6	143.85	143.12	143.7	29649029.0
2007-08-10 11:00:00	SPY	ETF	143.71	144.91	143.26	144.17	41320209.0
2007-08-10 11:30:00	SPY	ETF	144.17	144.98	143.81	144.98	18427549.0
2007-08-10 12:00:00	SPY	ETF	144.98	146.5	144.73	145.87	47513479.0
2007-08-10 12:30:00	SPY	ETF	145.87	146.13	144.68	144.73	22968107.0
2007-08-10 13:00:00	SPY	ETF	144.73	145.77	144.72	145.1	20781710.0
2007-08-10 13:30:00	SPY	ETF	145.1	145.24	144.1	144.66	23851845.0
2007-08-10 14:00:00	SPY	ETF	144.65	145.33	144.47	144.66	15107677.0
2007-08-10 14:30:00	SPY	ETF	144.66	144.95	144.14	144.41	11753510.0
2007-08-10 15:00:00	SPY	ETF	144.43	145.98	144.26	145.55	24863478.0
2007-08-10 15:30:00	SPY	ETF	145.55	146.23	143.83	145.54	33138217.0
2007-08-10 16:00:00	SPY	ETF	145.54	145.6	144.52	144.8	7185200.0
2007-08-10 16:30:00	SPY	ETF	144.85	145.5214	143.92	144.8	2894200.0
2007-08-10 17:00:00	SPY	ETF	144.83	145.0	144.83	144.84	34400.0
2007-08-10 17:30:00	SPY	ETF	144.85	144.85	144.76	144.85	114400.0
2007-08-10 18:00:00	SPY	ETF	144.85	145.25	144.8	145.1	174300.0
2007-08-10 18:30:00	SPY	ETF	145.13	145.2	145.1	145.2	8100.0
2007-08-10 19:00:00	SPY	ETF	145.2	145.2	144.96	145.02	1300.0
2007-08-10 19:30:00	SPY	ETF	145.05	145.05	145.0	145.0	2100.0
2007-08-10 20:00:00	SPY	ETF	145.08	145.08	145.08	145.08	100.0
2007-08-10 04:00:00	QQQ	ETF	47.54	47.54	47.54	47.54	2500.0
2007-08-10 04:30:00	QQQ	ETF	47.59	47.59	47.59	47.59	5000.0
2007-08-10 06:00:00	QQQ	ETF	47.27	47.32	47.26	47.32	27700.0
2007-08-10 06:30:00	QQQ	ETF	47.23	47.27	47.19	47.19	62600.0
2007-08-10 07:00:00	QQQ	ETF	47.2	47.2	47.04	47.08	334635.0
2007-08-10 07:30:00	QQQ	ETF	47.09	47.19	46.89	46.92	794664.0
2007-08-10 08:00:00	QQQ	ETF	46.92	47.11	46.89	47.06	2599349.0
2007-08-10 08:30:00	QQQ	ETF	47.04	47.21	47.0	47.14	1782072.0
2007-08-10 09:00:00	QQQ	ETF	47.14	47.3	47.11	47.21	1488348.0
2007-08-10 09:30:00	QQQ	ETF	47.21	47.31	46.99	47.25	28909932.0
2007-08-10 10:00:00	QQQ	ETF	47.24	47.29	46.78	46.8085	19799278.0
2007-08-10 10:30:00	QQQ	ETF	46.81	46.91	46.63	46.87	22882664.0
2007-08-10 11:00:00	QQQ	ETF	46.87	47.33	46.85	47.06	22195274.0
2007-08-10 11:30:00	QQQ	ETF	47.05	47.44	46.97	47.44	17317634.0
2007-08-10 12:00:00	QQQ	ETF	47.4301	47.83	47.34	47.61	29708157.0
2007-08-10 12:30:00	QQQ	ETF	47.6094	47.68	47.15	47.17	13227048.0
2007-08-10 13:00:00	QQQ	ETF	47.17	47.59	47.17	47.28	11085873.0

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

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