PREVIEW / etf_30min / 2007-10-22

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-10-22.parquet
  size:    141 KB
  rows:    5,191

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-22 04:00:00	SPY	ETF	149.25	149.25	149.17	149.2	25200.0
2007-10-22 04:30:00	SPY	ETF	149.15	149.15	149.0	149.0	6900.0
2007-10-22 05:00:00	SPY	ETF	148.88	148.88	148.88	148.88	8500.0
2007-10-22 05:30:00	SPY	ETF	148.76	148.76	148.76	148.76	5000.0
2007-10-22 06:00:00	SPY	ETF	148.75	148.81	148.7	148.81	13000.0
2007-10-22 06:30:00	SPY	ETF	148.72	148.76	148.5	148.6	156400.0
2007-10-22 07:00:00	SPY	ETF	148.61	148.83	148.56	148.63	913000.0
2007-10-22 07:30:00	SPY	ETF	148.63	148.7	148.51	148.55	651700.0
2007-10-22 08:00:00	SPY	ETF	148.58	149.05	148.53	148.93	3788000.0
2007-10-22 08:30:00	SPY	ETF	148.88	149.2	148.84	149.06	3002100.0
2007-10-22 09:00:00	SPY	ETF	149.08	149.09	148.73	148.83	3519433.0
2007-10-22 09:30:00	SPY	ETF	148.84	149.94	148.66	149.64	50568622.0
2007-10-22 10:00:00	SPY	ETF	149.64	150.25	149.43	149.92	26459400.0
2007-10-22 10:30:00	SPY	ETF	149.92	150.02	148.93	149.23	24956800.0
2007-10-22 11:00:00	SPY	ETF	149.23	150.002	149.03	149.64	15050200.0
2007-10-22 11:30:00	SPY	ETF	149.64	150.0	149.42	149.91	12886700.0
2007-10-22 12:00:00	SPY	ETF	149.9	149.989	149.37	149.61	10028900.0
2007-10-22 12:30:00	SPY	ETF	149.62	150.33	149.44	150.21	19307800.0
2007-10-22 13:00:00	SPY	ETF	150.21	150.69	150.18	150.68	16398200.0
2007-10-22 13:30:00	SPY	ETF	150.68	150.76	150.13	150.15	13748386.0
2007-10-22 14:00:00	SPY	ETF	150.16	150.618	150.14	150.2	7462500.0
2007-10-22 14:30:00	SPY	ETF	150.2	150.37	149.8	149.87	11618300.0
2007-10-22 15:00:00	SPY	ETF	149.86	149.99	149.47	149.78	14078800.0
2007-10-22 15:30:00	SPY	ETF	149.78	150.63	149.77	150.59	16953100.0
2007-10-22 16:00:00	SPY	ETF	150.56	150.7	149.98	150.59	2616400.0
2007-10-22 16:30:00	SPY	ETF	150.59	150.85	150.54	150.81	4129300.0
2007-10-22 17:00:00	SPY	ETF	150.76	150.92	149.7706	150.92	91000.0
2007-10-22 17:30:00	SPY	ETF	150.92	150.96	150.87	150.93	39200.0
2007-10-22 18:00:00	SPY	ETF	150.9	151.06	150.9	150.96	188200.0
2007-10-22 18:30:00	SPY	ETF	150.96	151.02	150.94	151.0	44200.0
2007-10-22 19:00:00	SPY	ETF	150.98	151.0	150.96	150.97	27800.0
2007-10-22 19:30:00	SPY	ETF	150.93	150.99	150.93	150.99	16300.0
2007-10-22 04:00:00	QQQ	ETF	52.21	52.21	52.21	52.21	100.0
2007-10-22 04:30:00	QQQ	ETF	52.1	52.1	52.1	52.1	500.0
2007-10-22 05:00:00	QQQ	ETF	52.08	52.08	52.08	52.08	300.0
2007-10-22 05:30:00	QQQ	ETF	52.09	52.09	52.07	52.08	46500.0
2007-10-22 06:30:00	QQQ	ETF	51.98	51.98	51.96	51.96	2100.0
2007-10-22 07:00:00	QQQ	ETF	51.98	52.09	51.95	52.06	1324494.0
2007-10-22 07:30:00	QQQ	ETF	52.06	52.08	52.0	52.0	202821.0
2007-10-22 08:00:00	QQQ	ETF	52.0	52.23	51.99	52.15	755812.0
2007-10-22 08:30:00	QQQ	ETF	52.16	52.26	52.14	52.19	1549865.0
2007-10-22 09:00:00	QQQ	ETF	52.19	52.26	52.09	52.16	1754257.0
2007-10-22 09:30:00	QQQ	ETF	52.17	52.74	52.02	52.6405	33082920.0
2007-10-22 10:00:00	QQQ	ETF	52.641	53.1185	52.62	52.872	27386296.0
2007-10-22 10:30:00	QQQ	ETF	52.88	52.94	52.46	52.58	16399205.0
2007-10-22 11:00:00	QQQ	ETF	52.58	52.72	52.47	52.72	9865108.0
2007-10-22 11:30:00	QQQ	ETF	52.7185	52.85	52.5	52.85	10065792.0
2007-10-22 12:00:00	QQQ	ETF	52.8415	52.8415	52.57	52.71	9831292.0
2007-10-22 12:30:00	QQQ	ETF	52.71	52.96	52.62	52.91	10821425.0
2007-10-22 13:00:00	QQQ	ETF	52.91	53.03	52.87	53.02	9433174.0

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

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