PREVIEW / etf_30min / 2008-10-20

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-10-20.parquet
  size:    176 KB
  rows:    6,222

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-10-20 04:30:00	SPY	ETF	95.85	96.0	95.58	96.0	8800.0
2008-10-20 05:00:00	SPY	ETF	96.0	96.2	95.94	96.08	26000.0
2008-10-20 05:30:00	SPY	ETF	96.18	96.18	95.44	95.44	3400.0
2008-10-20 06:00:00	SPY	ETF	95.61	95.61	95.44	95.44	25200.0
2008-10-20 06:30:00	SPY	ETF	95.47	96.1	95.4	95.85	70326.0
2008-10-20 07:00:00	SPY	ETF	95.85	95.85	94.74	94.81	747297.0
2008-10-20 07:30:00	SPY	ETF	94.78	95.09	94.4	94.9	1073379.0
2008-10-20 08:00:00	SPY	ETF	94.89	95.86	94.87	95.45	1582239.0
2008-10-20 08:30:00	SPY	ETF	95.47	95.86	94.76	95.26	1610016.0
2008-10-20 09:00:00	SPY	ETF	95.26	95.47	94.88	95.36	2606088.0
2008-10-20 09:30:00	SPY	ETF	95.35	96.45	94.77	96.31	39224493.0
2008-10-20 10:00:00	SPY	ETF	96.34	97.04	95.5602	95.68	30854400.0
2008-10-20 10:30:00	SPY	ETF	95.68	96.28	95.12	95.54	21597723.0
2008-10-20 11:00:00	SPY	ETF	95.54	95.59	94.35	95.43	19905499.0
2008-10-20 11:30:00	SPY	ETF	95.44	96.27	95.1	96.0	16773583.0
2008-10-20 12:00:00	SPY	ETF	96.0	96.57	95.67	96.22	14439312.0
2008-10-20 12:30:00	SPY	ETF	96.22	96.51	95.68	96.0	12074443.0
2008-10-20 13:00:00	SPY	ETF	95.99	96.67	95.54	96.48	14121731.0
2008-10-20 13:30:00	SPY	ETF	96.47	96.81	96.23	96.46	17264662.0
2008-10-20 14:00:00	SPY	ETF	96.45	97.18	96.2	96.47	21538438.0
2008-10-20 14:30:00	SPY	ETF	96.47	97.11	96.05	96.94	17869084.0
2008-10-20 15:00:00	SPY	ETF	96.94	97.33	96.53	97.0	24801781.0
2008-10-20 15:30:00	SPY	ETF	97.0	98.55	95.1	98.47	39399319.0
2008-10-20 16:00:00	SPY	ETF	98.47	99.24	94.0	99.13	15542118.0
2008-10-20 16:30:00	SPY	ETF	99.07	99.1	98.58	98.62	1557855.0
2008-10-20 17:00:00	SPY	ETF	98.65	98.81	98.6	98.6	358282.0
2008-10-20 17:30:00	SPY	ETF	98.71	98.78	98.6	98.62	89096.0
2008-10-20 18:00:00	SPY	ETF	98.62	98.8	98.6	98.7	49736.0
2008-10-20 18:30:00	SPY	ETF	98.67	98.75	98.6	98.61	44604.0
2008-10-20 19:00:00	SPY	ETF	98.62	98.7	98.6	98.7	58653.0
2008-10-20 19:30:00	SPY	ETF	98.7	98.74	98.49	98.69	65575.0
2008-10-20 04:00:00	QQQ	ETF	32.89	32.89	32.89	32.89	100.0
2008-10-20 04:30:00	QQQ	ETF	32.95	33.01	32.95	33.01	500.0
2008-10-20 05:00:00	QQQ	ETF	33.08	33.08	33.05	33.08	1000.0
2008-10-20 05:30:00	QQQ	ETF	33.2	33.2	33.03	33.03	300.0
2008-10-20 06:00:00	QQQ	ETF	32.91	32.91	32.9	32.9	200.0
2008-10-20 06:30:00	QQQ	ETF	32.95	33.0	32.95	33.0	400.0
2008-10-20 07:00:00	QQQ	ETF	33.08	33.08	32.66	32.66	39704.0
2008-10-20 07:30:00	QQQ	ETF	32.65	32.77	32.6	32.74	148881.0
2008-10-20 08:00:00	QQQ	ETF	32.69	32.97	32.69	32.93	258388.0
2008-10-20 08:30:00	QQQ	ETF	32.89	32.92	32.78	32.79	157833.0
2008-10-20 09:00:00	QQQ	ETF	32.79	32.87	32.63	32.78	685036.0
2008-10-20 09:30:00	QQQ	ETF	32.79	32.82	32.34	32.74	28648937.0
2008-10-20 10:00:00	QQQ	ETF	32.74	32.95	32.22	32.27	21891107.0
2008-10-20 10:30:00	QQQ	ETF	32.27	32.47	32.0	32.17	16297776.0
2008-10-20 11:00:00	QQQ	ETF	32.17	32.18	31.7	32.09	18702579.0
2008-10-20 11:30:00	QQQ	ETF	32.09	32.49	31.95	32.37	16894327.0
2008-10-20 12:00:00	QQQ	ETF	32.38	32.59	32.08	32.4899	9856124.0
2008-10-20 12:30:00	QQQ	ETF	32.49	32.63	32.28	32.32	10715068.0
2008-10-20 13:00:00	QQQ	ETF	32.32	32.54	32.17	32.51	12025502.0

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

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