PREVIEW / etf_30min / 2008-09-04

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-09-04.parquet
  size:    177 KB
  rows:    6,178

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-09-04 04:30:00	SPY	ETF	127.5	127.5	127.5	127.5	100.0
2008-09-04 05:30:00	SPY	ETF	127.39	127.39	127.37	127.37	1000.0
2008-09-04 06:00:00	SPY	ETF	127.36	127.45	127.3	127.43	27900.0
2008-09-04 06:30:00	SPY	ETF	127.54	127.7	127.54	127.64	71000.0
2008-09-04 07:00:00	SPY	ETF	127.68	127.69	127.36	127.58	296995.0
2008-09-04 07:30:00	SPY	ETF	127.57	127.67	127.43	127.6	181263.0
2008-09-04 08:00:00	SPY	ETF	127.58	127.82	127.28	127.42	1793338.0
2008-09-04 08:30:00	SPY	ETF	127.41	127.88	127.11	127.29	2457063.0
2008-09-04 09:00:00	SPY	ETF	127.28	127.88	126.85	126.95	3525072.0
2008-09-04 09:30:00	SPY	ETF	126.97	127.18	126.58	126.83	27148389.0
2008-09-04 10:00:00	SPY	ETF	126.83	127.23	126.71	126.84	23547977.0
2008-09-04 10:30:00	SPY	ETF	126.84	126.85	125.59	125.82	39958451.0
2008-09-04 11:00:00	SPY	ETF	125.81	126.1	125.2	125.362	31907134.0
2008-09-04 11:30:00	SPY	ETF	125.37	125.69	125.3	125.38	15323094.0
2008-09-04 12:00:00	SPY	ETF	125.38	125.78	125.37	125.41	13946774.0
2008-09-04 12:30:00	SPY	ETF	125.42	125.4772	125.03	125.12	13662465.0
2008-09-04 13:00:00	SPY	ETF	125.12	126.52	124.56	124.65	16839357.0
2008-09-04 13:30:00	SPY	ETF	124.65	124.9	124.57	124.87	19564876.0
2008-09-04 14:00:00	SPY	ETF	124.87	124.88	124.09	124.5	29374226.0
2008-09-04 14:30:00	SPY	ETF	124.5	126.2	124.24	124.6	18709207.0
2008-09-04 15:00:00	SPY	ETF	124.6	125.0	124.4	124.68	29733967.0
2008-09-04 15:30:00	SPY	ETF	124.67	124.78	124.0	124.08	42932664.0
2008-09-04 16:00:00	SPY	ETF	124.1001	124.3856	123.96	124.02	5169666.0
2008-09-04 16:30:00	SPY	ETF	124.05	124.468	124.02	124.16	224071.0
2008-09-04 17:00:00	SPY	ETF	124.17	126.2	123.99	124.0	165827.0
2008-09-04 17:30:00	SPY	ETF	124.0	124.03	123.94	123.95	121945.0
2008-09-04 18:00:00	SPY	ETF	123.99	124.32	123.27	123.4	301187.0
2008-09-04 18:30:00	SPY	ETF	123.4	123.4	123.08	123.34	210186.0
2008-09-04 19:00:00	SPY	ETF	123.33	123.5	123.33	123.49	110508.0
2008-09-04 19:30:00	SPY	ETF	123.46	123.56	123.36	123.5	35902.0
2008-09-04 04:30:00	QQQ	ETF	45.0	45.0	44.9	44.9	900.0
2008-09-04 06:30:00	QQQ	ETF	44.85	44.85	44.85	44.85	300.0
2008-09-04 07:00:00	QQQ	ETF	44.92	44.95	44.85	44.91	59500.0
2008-09-04 07:30:00	QQQ	ETF	44.92	44.96	44.88	44.94	102129.0
2008-09-04 08:00:00	QQQ	ETF	44.95	44.96	44.82	44.85	437896.0
2008-09-04 08:30:00	QQQ	ETF	44.85	44.93	44.7	44.85	738787.0
2008-09-04 09:00:00	QQQ	ETF	44.84	44.84	44.74	44.84	2042437.0
2008-09-04 09:30:00	QQQ	ETF	44.84	44.86	44.62	44.69	17629376.0
2008-09-04 10:00:00	QQQ	ETF	44.68	44.91	44.65	44.73	17622362.0
2008-09-04 10:30:00	QQQ	ETF	44.73	44.73	44.35	44.47	24695254.0
2008-09-04 11:00:00	QQQ	ETF	44.46	44.51	44.26	44.35	18067359.0
2008-09-04 11:30:00	QQQ	ETF	44.36	44.55	44.29	44.42	11842567.0
2008-09-04 12:00:00	QQQ	ETF	44.4195	44.62	44.39	44.41	12623860.0
2008-09-04 12:30:00	QQQ	ETF	44.41	44.6	44.19	44.2701	8501440.0
2008-09-04 13:00:00	QQQ	ETF	44.275	44.318	43.96	44.02	10953697.0
2008-09-04 13:30:00	QQQ	ETF	44.02	44.1	43.98	44.05	5766058.0
2008-09-04 14:00:00	QQQ	ETF	44.04	44.05	43.81	43.95	11948896.0
2008-09-04 14:30:00	QQQ	ETF	43.95	43.96	43.815	43.92	11082332.0
2008-09-04 15:00:00	QQQ	ETF	43.92	44.09	43.85	43.929	18961054.0
2008-09-04 15:30:00	QQQ	ETF	43.92	43.99	43.67	43.67	25369569.0

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

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