PREVIEW / etf_30min / 2008-12-05

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-12-05.parquet
  size:    187 KB
  rows:    6,568

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
2008-12-05 04:00:00	SPY	ETF	85.32	85.56	85.29	85.56	3211.0
2008-12-05 04:30:00	SPY	ETF	85.48	85.54	85.48	85.5	1600.0
2008-12-05 05:00:00	SPY	ETF	85.3	85.3	85.3	85.3	300.0
2008-12-05 05:30:00	SPY	ETF	85.3	85.3	85.26	85.26	700.0
2008-12-05 06:00:00	SPY	ETF	85.09	85.09	84.91	84.94	7100.0
2008-12-05 06:30:00	SPY	ETF	84.91	85.1	84.91	85.0	2300.0
2008-12-05 07:00:00	SPY	ETF	85.1	85.1	84.35	84.48	788098.0
2008-12-05 07:30:00	SPY	ETF	84.5	84.57	84.33	84.4	513585.0
2008-12-05 08:00:00	SPY	ETF	84.38	84.6	83.9	84.16	3732225.0
2008-12-05 08:30:00	SPY	ETF	84.03	85.07	82.74	83.84	14526419.0
2008-12-05 09:00:00	SPY	ETF	83.85	85.3	83.53	83.63	4731647.0
2008-12-05 09:30:00	SPY	ETF	83.65	84.66	83.25	83.27	43772029.0
2008-12-05 10:00:00	SPY	ETF	83.25	83.85	82.45	82.87	34260391.0
2008-12-05 10:30:00	SPY	ETF	82.87	83.38	82.24	83.11	31551062.0
2008-12-05 11:00:00	SPY	ETF	83.11	83.39	82.61	82.71	23795476.0
2008-12-05 11:30:00	SPY	ETF	82.7	83.79	82.48	83.5409	19554417.0
2008-12-05 12:00:00	SPY	ETF	83.55	84.0	83.39	83.97	14460208.0
2008-12-05 12:30:00	SPY	ETF	83.98	83.98	83.06	83.41	13898595.0
2008-12-05 13:00:00	SPY	ETF	83.41	84.39	82.3	83.93	16788853.0
2008-12-05 13:30:00	SPY	ETF	83.93	85.58	83.91	85.05	32384793.0
2008-12-05 14:00:00	SPY	ETF	85.048	85.38	84.42	84.9	29554345.0
2008-12-05 14:30:00	SPY	ETF	84.89	87.32	84.72	86.88	44266694.0
2008-12-05 15:00:00	SPY	ETF	86.88	87.59	86.09	87.21	53938591.0
2008-12-05 15:30:00	SPY	ETF	87.2	88.42	87.19	88.04	70201965.0
2008-12-05 16:00:00	SPY	ETF	88.09	88.1	82.8	87.7	10971510.0
2008-12-05 16:30:00	SPY	ETF	87.72	87.75	87.55	87.59	3675351.0
2008-12-05 17:00:00	SPY	ETF	87.59	87.72	87.55	87.68	141849.0
2008-12-05 17:30:00	SPY	ETF	87.7	87.74	87.65	87.66	3088592.0
2008-12-05 18:00:00	SPY	ETF	87.67	87.72	87.6	87.62	37690.0
2008-12-05 18:30:00	SPY	ETF	87.62	87.75	87.62	87.75	113587.0
2008-12-05 19:00:00	SPY	ETF	87.8	87.8	87.69	87.7	6877.0
2008-12-05 19:30:00	SPY	ETF	87.72	87.8	87.66	87.72	13727.0
2008-12-05 04:00:00	QQQ	ETF	27.98	27.98	27.98	27.98	200.0
2008-12-05 05:30:00	QQQ	ETF	27.88	27.88	27.83	27.83	1100.0
2008-12-05 06:00:00	QQQ	ETF	27.78	27.78	27.78	27.78	100.0
2008-12-05 07:00:00	QQQ	ETF	27.72	27.72	27.58	27.62	250068.0
2008-12-05 07:30:00	QQQ	ETF	27.62	27.62	27.55	27.55	229505.0
2008-12-05 08:00:00	QQQ	ETF	27.6	27.71	27.41	27.63	2143551.0
2008-12-05 08:30:00	QQQ	ETF	27.51	27.63	27.17	27.49	4216062.0
2008-12-05 09:00:00	QQQ	ETF	27.5	27.62	27.43	27.49	2534067.0
2008-12-05 09:30:00	QQQ	ETF	27.49	27.7	27.23	27.2395	21355541.0
2008-12-05 10:00:00	QQQ	ETF	27.23	27.3	26.95	27.1275	17214533.0
2008-12-05 10:30:00	QQQ	ETF	27.12	27.37	26.98	27.29	16260708.0
2008-12-05 11:00:00	QQQ	ETF	27.29	27.37	27.0	27.16	8169164.0
2008-12-05 11:30:00	QQQ	ETF	27.16	27.48	27.1	27.4	8014705.0
2008-12-05 12:00:00	QQQ	ETF	27.3995	27.51	27.33	27.47	5050421.0
2008-12-05 12:30:00	QQQ	ETF	27.47	27.47	27.25	27.36	4051004.0
2008-12-05 13:00:00	QQQ	ETF	27.37	27.67	27.28	27.5485	6263197.0
2008-12-05 13:30:00	QQQ	ETF	27.5401	28.36	27.53	28.21	17726224.0
2008-12-05 14:00:00	QQQ	ETF	28.211	28.29	27.93	28.069	14675817.0

> showing 50 of 6,568 rows — these rows as CSV

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