PREVIEW / etf_30min / 2008-11-24

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-11-24.parquet
  size:    190 KB
  rows:    6,771

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-11-24 04:00:00	SPY	ETF	79.88	80.28	79.88	80.28	12100.0
2008-11-24 04:30:00	SPY	ETF	80.45	80.93	80.45	80.88	11100.0
2008-11-24 05:00:00	SPY	ETF	80.88	81.2	80.75	81.09	21526.0
2008-11-24 05:30:00	SPY	ETF	81.15	81.19	80.75	80.75	21017.0
2008-11-24 06:00:00	SPY	ETF	80.82	81.78	80.82	81.78	19900.0
2008-11-24 06:30:00	SPY	ETF	81.74	82.01	81.69	81.9	247900.0
2008-11-24 07:00:00	SPY	ETF	81.88	82.15	81.75	81.77	974493.0
2008-11-24 07:30:00	SPY	ETF	81.77	82.13	81.72	81.76	1495828.0
2008-11-24 08:00:00	SPY	ETF	81.76	81.83	79.35	81.49	2742322.0
2008-11-24 08:30:00	SPY	ETF	81.5	81.79	81.46	81.76	2377723.0
2008-11-24 09:00:00	SPY	ETF	81.78	82.12	81.6	81.87	1605486.0
2008-11-24 09:30:00	SPY	ETF	81.92	82.25	81.17	81.98	37228101.0
2008-11-24 10:00:00	SPY	ETF	81.96	83.56	81.94	83.56	39608941.0
2008-11-24 10:30:00	SPY	ETF	83.56	84.02	83.24	83.93	40878691.0
2008-11-24 11:00:00	SPY	ETF	83.94	84.25	83.41	83.98	32431912.0
2008-11-24 11:30:00	SPY	ETF	83.98	84.66	83.79	84.25	26866378.0
2008-11-24 12:00:00	SPY	ETF	84.25	84.51	82.94	83.03	31643962.0
2008-11-24 12:30:00	SPY	ETF	83.05	84.0	83.0	83.85	23821529.0
2008-11-24 13:00:00	SPY	ETF	83.86	84.17	83.41	84.05	21235874.0
2008-11-24 13:30:00	SPY	ETF	84.0495	84.57	83.57	84.57	22228152.0
2008-11-24 14:00:00	SPY	ETF	84.57	84.59	83.25	84.42	24908284.0
2008-11-24 14:30:00	SPY	ETF	84.42	84.94	83.95	84.56	27170616.0
2008-11-24 15:00:00	SPY	ETF	84.56	86.04	84.25	86.03	41108878.0
2008-11-24 15:30:00	SPY	ETF	86.04	86.985	84.1	84.94	103009824.0
2008-11-24 16:00:00	SPY	ETF	84.9	85.71	82.5	85.2	21346813.0
2008-11-24 16:30:00	SPY	ETF	85.2	85.2	80.3614	84.95	6851172.0
2008-11-24 17:00:00	SPY	ETF	85.0	85.25	80.3614	85.16	1279356.0
2008-11-24 17:30:00	SPY	ETF	85.15	85.24	81.94	85.16	70455.0
2008-11-24 18:00:00	SPY	ETF	85.16	85.46	84.92	85.36	3277955.0
2008-11-24 18:30:00	SPY	ETF	85.37	85.44	85.28	85.28	98000.0
2008-11-24 19:00:00	SPY	ETF	85.31	85.45	85.28	85.31	17635.0
2008-11-24 19:30:00	SPY	ETF	85.33	85.42	85.31	85.35	22160.0
2008-11-24 04:30:00	QQQ	ETF	27.1	27.11	27.1	27.11	900.0
2008-11-24 05:00:00	QQQ	ETF	27.09	27.22	27.04	27.21	1669.0
2008-11-24 05:30:00	QQQ	ETF	27.21	27.21	27.08	27.08	500.0
2008-11-24 06:00:00	QQQ	ETF	27.2	27.34	27.2	27.34	2156.0
2008-11-24 06:30:00	QQQ	ETF	27.4	27.4	27.35	27.35	25939.0
2008-11-24 07:00:00	QQQ	ETF	27.35	27.47	27.28	27.35	254367.0
2008-11-24 07:30:00	QQQ	ETF	27.34	27.41	27.31	27.32	241152.0
2008-11-24 08:00:00	QQQ	ETF	27.32	27.35	26.65	27.28	783950.0
2008-11-24 08:30:00	QQQ	ETF	27.28	27.46	27.24	27.46	1601433.0
2008-11-24 09:00:00	QQQ	ETF	27.46	27.48	27.2	27.22	1886615.0
2008-11-24 09:30:00	QQQ	ETF	27.22	27.34	26.98	27.28	28081074.0
2008-11-24 10:00:00	QQQ	ETF	27.29	27.86	27.29	27.8399	19417508.0
2008-11-24 10:30:00	QQQ	ETF	27.83	27.97	27.64	27.89	18890417.0
2008-11-24 11:00:00	QQQ	ETF	27.89	27.95	27.68	27.8599	10650636.0
2008-11-24 11:30:00	QQQ	ETF	27.85	28.04	27.75	27.96	11858447.0
2008-11-24 12:00:00	QQQ	ETF	27.9599	28.05	27.5	27.53	18826780.0
2008-11-24 12:30:00	QQQ	ETF	27.53	27.84	27.52	27.75	11339435.0
2008-11-24 13:00:00	QQQ	ETF	27.75	27.84	27.58	27.79	7648148.0

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

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