PREVIEW / etf_30min / 2007-11-28

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-11-28.parquet
  size:    150 KB
  rows:    5,336

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-28 05:30:00	SPY	ETF	142.62	142.62	142.62	142.62	12500.0
2007-11-28 06:00:00	SPY	ETF	142.84	142.84	142.75	142.75	3100.0
2007-11-28 06:30:00	SPY	ETF	142.91	143.16	142.91	143.07	115800.0
2007-11-28 07:00:00	SPY	ETF	143.11	143.78	143.06	143.7	650800.0
2007-11-28 07:30:00	SPY	ETF	143.73	143.75	143.53	143.57	1011500.0
2007-11-28 08:00:00	SPY	ETF	143.56	144.2	142.5	143.92	7287700.0
2007-11-28 08:30:00	SPY	ETF	143.94	144.4	143.56	144.28	4710100.0
2007-11-28 09:00:00	SPY	ETF	144.27	144.27	143.97	144.19	1335400.0
2007-11-28 09:30:00	SPY	ETF	144.19	145.26	144.14	145.19	28385061.0
2007-11-28 10:00:00	SPY	ETF	145.19	145.49	144.78	145.49	23769867.0
2007-11-28 10:30:00	SPY	ETF	145.49	146.25	145.45	145.92	26961845.0
2007-11-28 11:00:00	SPY	ETF	145.93	146.05	145.66	145.81	11571867.0
2007-11-28 11:30:00	SPY	ETF	145.81	146.03	145.61	145.91	8671800.0
2007-11-28 12:00:00	SPY	ETF	145.9122	146.28	145.9	146.16	14421690.0
2007-11-28 12:30:00	SPY	ETF	146.168	146.28	145.97	146.07	7336706.0
2007-11-28 13:00:00	SPY	ETF	146.06	146.57	145.95	146.48	12394849.0
2007-11-28 13:30:00	SPY	ETF	146.47	146.97	146.39	146.75	13740408.0
2007-11-28 14:00:00	SPY	ETF	146.75	147.2	146.65	146.85	19045827.0
2007-11-28 14:30:00	SPY	ETF	146.85	147.16	146.64	146.92	11238620.0
2007-11-28 15:00:00	SPY	ETF	146.92	147.47	146.84	147.35	13434600.0
2007-11-28 15:30:00	SPY	ETF	147.36	147.45	146.6	147.25	31637517.0
2007-11-28 16:00:00	SPY	ETF	147.26	147.26	142.09	147.08	14218700.0
2007-11-28 16:30:00	SPY	ETF	147.08	147.11	146.89	146.9	1890700.0
2007-11-28 17:00:00	SPY	ETF	146.87	146.95	146.83	146.88	243500.0
2007-11-28 17:30:00	SPY	ETF	146.89	146.95	146.8	146.95	17800.0
2007-11-28 18:00:00	SPY	ETF	146.91	146.95	146.8	146.81	2018600.0
2007-11-28 18:30:00	SPY	ETF	146.81	146.95	146.8	146.89	13400.0
2007-11-28 19:00:00	SPY	ETF	146.99	146.99	146.91	146.94	4700.0
2007-11-28 19:30:00	SPY	ETF	146.95	147.09	146.95	147.09	15900.0
2007-11-28 06:00:00	QQQ	ETF	49.98	49.98	49.98	49.98	1000.0
2007-11-28 06:30:00	QQQ	ETF	50.03	50.16	50.03	50.15	59300.0
2007-11-28 07:00:00	QQQ	ETF	50.12	50.4	50.12	50.4	94191.0
2007-11-28 07:30:00	QQQ	ETF	50.38	50.47	50.35	50.43	870080.0
2007-11-28 08:00:00	QQQ	ETF	50.43	50.71	50.0	50.63	3015643.0
2007-11-28 08:30:00	QQQ	ETF	50.64	50.78	50.57	50.77	2284112.0
2007-11-28 09:00:00	QQQ	ETF	50.75	50.75	50.62	50.64	1928194.0
2007-11-28 09:30:00	QQQ	ETF	50.64	50.87	50.6	50.78	33039918.0
2007-11-28 10:00:00	QQQ	ETF	50.78	50.98	50.6	50.9799	14855660.0
2007-11-28 10:30:00	QQQ	ETF	50.98	51.44	50.96	51.31	23825218.0
2007-11-28 11:00:00	QQQ	ETF	51.31	51.37	51.18	51.26	7637501.0
2007-11-28 11:30:00	QQQ	ETF	51.26	51.27	51.08	51.2399	12057322.0
2007-11-28 12:00:00	QQQ	ETF	51.24	51.42	51.22	51.3099	9808089.0
2007-11-28 12:30:00	QQQ	ETF	51.31	51.35	51.25	51.28	3878896.0
2007-11-28 13:00:00	QQQ	ETF	51.28	51.44	51.23	51.37	11388765.0
2007-11-28 13:30:00	QQQ	ETF	51.37	51.59	51.33	51.52	10815117.0
2007-11-28 14:00:00	QQQ	ETF	51.52	51.58	51.39	51.422	20584131.0
2007-11-28 14:30:00	QQQ	ETF	51.43	51.52	51.32	51.47	7808514.0
2007-11-28 15:00:00	QQQ	ETF	51.47	51.7	51.43	51.63	11634182.0
2007-11-28 15:30:00	QQQ	ETF	51.63	51.63	51.2999	51.54	30040305.0
2007-11-28 16:00:00	QQQ	ETF	51.53	51.53	51.33	51.33	7097282.0

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

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