PREVIEW / etf_30min / 2008-07-03

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-07-03.parquet
  size:    110 KB
  rows:    3,544

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-07-03 04:30:00	SPY	ETF	126.52	126.52	126.5	126.5	200.0
2008-07-03 05:00:00	SPY	ETF	126.66	126.67	126.4	126.4	800.0
2008-07-03 06:00:00	SPY	ETF	126.2	126.23	126.14	126.23	2200.0
2008-07-03 06:30:00	SPY	ETF	126.21	126.21	126.1	126.1	13000.0
2008-07-03 07:00:00	SPY	ETF	126.12	126.26	125.95	126.23	317961.0
2008-07-03 07:30:00	SPY	ETF	126.2	126.39	125.84	126.18	712674.0
2008-07-03 08:00:00	SPY	ETF	126.6	126.6	126.09	126.09	2464152.0
2008-07-03 08:30:00	SPY	ETF	126.09	127.11	125.91	127.0	23340124.0
2008-07-03 09:00:00	SPY	ETF	126.99	127.22	126.18	127.1	4058783.0
2008-07-03 09:30:00	SPY	ETF	127.11	127.11	125.42	125.96	47559159.0
2008-07-03 10:00:00	SPY	ETF	125.97	126.42	124.99	126.38	47764176.0
2008-07-03 10:30:00	SPY	ETF	126.38	126.88	126.24	126.55	29037420.0
2008-07-03 11:00:00	SPY	ETF	126.55	127.06	126.39	127.05	21265170.0
2008-07-03 11:30:00	SPY	ETF	127.05	127.07	126.5	126.65	19627293.0
2008-07-03 12:00:00	SPY	ETF	126.64	126.68	126.06	126.47	13781712.0
2008-07-03 12:30:00	SPY	ETF	126.465	126.5	125.98	126.14	23877634.0
2008-07-03 13:00:00	SPY	ETF	126.15	126.5	126.05	126.39	2254504.0
2008-07-03 13:30:00	SPY	ETF	126.39	126.43	126.32	126.35	23861.0
2008-07-03 14:00:00	SPY	ETF	126.35	126.36	126.35	126.35	1100.0
2008-07-03 14:30:00	SPY	ETF	126.36	126.4	126.32	126.4	21763.0
2008-07-03 15:00:00	SPY	ETF	126.4	126.44	126.35	126.44	10485.0
2008-07-03 15:30:00	SPY	ETF	126.44	126.44	126.38	126.38	1409.0
2008-07-03 16:00:00	SPY	ETF	126.4	126.4	126.34	126.34	10000.0
2008-07-03 16:30:00	SPY	ETF	126.34	126.43	126.18	126.25	7212.0
2008-07-03 04:00:00	QQQ	ETF	44.64	44.64	44.64	44.64	100.0
2008-07-03 05:00:00	QQQ	ETF	44.7	44.7	44.67	44.67	1500.0
2008-07-03 05:30:00	QQQ	ETF	44.64	44.65	44.64	44.65	1200.0
2008-07-03 06:30:00	QQQ	ETF	44.58	44.58	44.57	44.57	17200.0
2008-07-03 07:00:00	QQQ	ETF	44.52	44.63	44.48	44.61	182509.0
2008-07-03 07:30:00	QQQ	ETF	44.61	44.63	44.43	44.56	413350.0
2008-07-03 08:00:00	QQQ	ETF	44.55	44.6	44.45	44.5	1567578.0
2008-07-03 08:30:00	QQQ	ETF	44.49	44.94	44.42	44.88	6428290.0
2008-07-03 09:00:00	QQQ	ETF	44.87	44.99	44.7212	44.98	960514.0
2008-07-03 09:30:00	QQQ	ETF	44.96	44.99	44.41	44.62	22734651.0
2008-07-03 10:00:00	QQQ	ETF	44.62	44.91	44.28	44.9	24574325.0
2008-07-03 10:30:00	QQQ	ETF	44.9	45.08	44.82	44.9	14965861.0
2008-07-03 11:00:00	QQQ	ETF	44.9	45.05	44.85	45.01	9700464.0
2008-07-03 11:30:00	QQQ	ETF	45.01	45.03	44.82	44.865	9085989.0
2008-07-03 12:00:00	QQQ	ETF	44.86	44.88	44.58	44.769	11180247.0
2008-07-03 12:30:00	QQQ	ETF	44.77	44.77	44.56	44.65	14878373.0
2008-07-03 13:00:00	QQQ	ETF	44.66	44.8	44.61	44.65	3017185.0
2008-07-03 13:30:00	QQQ	ETF	44.66	44.68	44.6	44.6	130000.0
2008-07-03 14:00:00	QQQ	ETF	44.61	44.61	44.55	44.55	16839.0
2008-07-03 14:30:00	QQQ	ETF	44.57	44.59	44.56	44.58	6192.0
2008-07-03 15:00:00	QQQ	ETF	44.58	44.58	44.56	44.58	19338.0
2008-07-03 15:30:00	QQQ	ETF	44.59	44.64	44.59	44.64	1900.0
2008-07-03 16:00:00	QQQ	ETF	44.67	44.75	44.64	44.64	5600.0
2008-07-03 07:00:00	IWM	ETF	66.81	66.92	66.81	66.92	22292.0
2008-07-03 07:30:00	IWM	ETF	66.93	66.95	66.7	66.7	33808.0
2008-07-03 08:00:00	IWM	ETF	67.2	67.2	66.18	66.91	155254.0

> showing 50 of 3,544 rows — these rows as CSV

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