PREVIEW / etf_30min / 2008-10-21

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-10-21.parquet
  size:    175 KB
  rows:    6,266

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-21 04:00:00	SPY	ETF	98.15	98.15	98.0	98.0	200.0
2008-10-21 04:30:00	SPY	ETF	97.87	97.9	97.63	97.63	300.0
2008-10-21 05:30:00	SPY	ETF	98.18	98.18	98.18	98.18	100.0
2008-10-21 06:00:00	SPY	ETF	98.17	98.43	98.17	98.28	5000.0
2008-10-21 06:30:00	SPY	ETF	98.2	98.33	98.1	98.32	24300.0
2008-10-21 07:00:00	SPY	ETF	98.33	98.43	97.8	97.9	273011.0
2008-10-21 07:30:00	SPY	ETF	98.0	98.03	97.4	97.6	1190860.0
2008-10-21 08:00:00	SPY	ETF	97.6	98.81	97.15	97.47	2034228.0
2008-10-21 08:30:00	SPY	ETF	97.48	97.6	97.11	97.33	1651374.0
2008-10-21 09:00:00	SPY	ETF	97.34	98.2	96.41	96.96	4952042.0
2008-10-21 09:30:00	SPY	ETF	96.97	97.6	96.62	97.41	31089483.0
2008-10-21 10:00:00	SPY	ETF	97.4	98.64	97.15	98.2	29344612.0
2008-10-21 10:30:00	SPY	ETF	98.21	98.25	97.3	97.4	20065555.0
2008-10-21 11:00:00	SPY	ETF	97.4	97.8	97.2	97.39	14368137.0
2008-10-21 11:30:00	SPY	ETF	97.38	97.73	95.86	96.0	21892996.0
2008-10-21 12:00:00	SPY	ETF	96.0	96.37	95.64	96.12	24975056.0
2008-10-21 12:30:00	SPY	ETF	96.11	96.59	95.42	95.44	18717623.0
2008-10-21 13:00:00	SPY	ETF	95.44	96.83	95.4	96.39	19486085.0
2008-10-21 13:30:00	SPY	ETF	96.4	96.94	96.12	96.41	16706413.0
2008-10-21 14:00:00	SPY	ETF	96.4	97.73	96.4	97.69	19730816.0
2008-10-21 14:30:00	SPY	ETF	97.7095	98.41	97.4	97.76	28272218.0
2008-10-21 15:00:00	SPY	ETF	97.76	98.4	96.59	96.63	30424957.0
2008-10-21 15:30:00	SPY	ETF	96.62	96.83	95.22	95.5	49031037.0
2008-10-21 16:00:00	SPY	ETF	95.47	98.5672	93.5055	95.8	12968302.0
2008-10-21 16:30:00	SPY	ETF	95.91	96.22	94.99	95.31	5006759.0
2008-10-21 17:00:00	SPY	ETF	95.31	96.57	95.16	96.41	1006888.0
2008-10-21 17:30:00	SPY	ETF	96.5	97.0	96.37	96.97	219182.0
2008-10-21 18:00:00	SPY	ETF	96.9	96.97	96.66	96.73	60954.0
2008-10-21 18:30:00	SPY	ETF	96.78	96.91	96.74	96.74	73011.0
2008-10-21 19:00:00	SPY	ETF	96.74	96.86	96.71	96.81	24274.0
2008-10-21 19:30:00	SPY	ETF	96.83	96.97	96.6	96.62	82389.0
2008-10-21 04:00:00	QQQ	ETF	33.06	33.06	33.06	33.06	100.0
2008-10-21 04:30:00	QQQ	ETF	32.9	32.9	32.9	32.9	900.0
2008-10-21 05:30:00	QQQ	ETF	32.9	32.9	32.87	32.88	1800.0
2008-10-21 06:00:00	QQQ	ETF	32.94	32.97	32.94	32.97	200.0
2008-10-21 06:30:00	QQQ	ETF	32.93	32.95	32.9	32.9	3200.0
2008-10-21 07:00:00	QQQ	ETF	32.93	32.93	32.76	32.76	32224.0
2008-10-21 07:30:00	QQQ	ETF	32.82	32.82	32.64	32.73	217504.0
2008-10-21 08:00:00	QQQ	ETF	32.74	32.85	32.69	32.74	310210.0
2008-10-21 08:30:00	QQQ	ETF	32.74	32.8	32.59	32.65	568228.0
2008-10-21 09:00:00	QQQ	ETF	32.66	32.8	32.46	32.65	1667311.0
2008-10-21 09:30:00	QQQ	ETF	32.64	32.79	32.43	32.77	19667585.0
2008-10-21 10:00:00	QQQ	ETF	32.78	33.25	32.7	33.0	20270557.0
2008-10-21 10:30:00	QQQ	ETF	33.01	33.03	32.7	32.7	11257638.0
2008-10-21 11:00:00	QQQ	ETF	32.7	32.84	32.6	32.66	8435203.0
2008-10-21 11:30:00	QQQ	ETF	32.66	32.79	32.06	32.1	15430214.0
2008-10-21 12:00:00	QQQ	ETF	32.1	32.25	31.94	32.0695	17104412.0
2008-10-21 12:30:00	QQQ	ETF	32.067	32.25	31.76	31.76	11910453.0
2008-10-21 13:00:00	QQQ	ETF	31.76	32.28	31.75	32.07	11997474.0
2008-10-21 13:30:00	QQQ	ETF	32.07	32.24	31.92	32.04	9646093.0

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

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