PREVIEW / etf_30min / 2008-08-29

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-08-29.parquet
  size:    162 KB
  rows:    5,713

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-08-29 04:00:00	SPY	ETF	129.75	129.77	129.75	129.77	5100.0
2008-08-29 04:30:00	SPY	ETF	129.77	129.77	129.77	129.77	500.0
2008-08-29 05:00:00	SPY	ETF	129.84	129.85	129.84	129.85	10000.0
2008-08-29 05:30:00	SPY	ETF	130.05	130.05	130.05	130.05	5000.0
2008-08-29 06:00:00	SPY	ETF	129.94	129.94	129.91	129.91	200.0
2008-08-29 06:30:00	SPY	ETF	129.96	129.99	129.91	129.96	16900.0
2008-08-29 07:00:00	SPY	ETF	129.94	130.01	129.84	129.95	61407.0
2008-08-29 07:30:00	SPY	ETF	129.92	130.15	129.88	130.09	866485.0
2008-08-29 08:00:00	SPY	ETF	129.88	130.1	129.78	129.98	1191473.0
2008-08-29 08:30:00	SPY	ETF	130.04	130.19	129.74	129.8	1693555.0
2008-08-29 09:00:00	SPY	ETF	129.8	130.19	129.68	129.68	2145042.0
2008-08-29 09:30:00	SPY	ETF	129.68	130.14	129.57	129.91	32451818.0
2008-08-29 10:00:00	SPY	ETF	129.91	130.0	129.4	129.48	15506620.0
2008-08-29 10:30:00	SPY	ETF	129.48	129.6	129.05	129.12	14938336.0
2008-08-29 11:00:00	SPY	ETF	129.12	129.35	129.099	129.17	10676311.0
2008-08-29 11:30:00	SPY	ETF	129.17	129.32	129.03	129.18	8923780.0
2008-08-29 12:00:00	SPY	ETF	129.18	129.18	128.77	128.82	9788136.0
2008-08-29 12:30:00	SPY	ETF	128.82	129.15	128.81	129.12	8345090.0
2008-08-29 13:00:00	SPY	ETF	129.12	129.54	129.1	129.4	14520488.0
2008-08-29 13:30:00	SPY	ETF	129.4	129.43	129.14	129.23	5197881.0
2008-08-29 14:00:00	SPY	ETF	129.23	129.46	129.2	129.43	5009418.0
2008-08-29 14:30:00	SPY	ETF	129.43	129.45	129.2	129.38	5278319.0
2008-08-29 15:00:00	SPY	ETF	129.38	129.4	128.87	128.89	10389082.0
2008-08-29 15:30:00	SPY	ETF	128.89	129.96	128.61	128.69	23060492.0
2008-08-29 16:00:00	SPY	ETF	128.63	130.4011	128.51	128.77	8607900.0
2008-08-29 16:30:00	SPY	ETF	128.79	128.83	127.4634	128.74	2943732.0
2008-08-29 17:00:00	SPY	ETF	128.65	128.76	128.65	128.65	34500.0
2008-08-29 17:30:00	SPY	ETF	128.65	128.65	128.62	128.65	7238.0
2008-08-29 18:00:00	SPY	ETF	128.65	128.65	128.62	128.63	2695.0
2008-08-29 18:30:00	SPY	ETF	128.63	128.65	128.63	128.65	3416.0
2008-08-29 19:00:00	SPY	ETF	128.65	128.65	128.58	128.58	4770.0
2008-08-29 19:30:00	SPY	ETF	128.59	128.65	128.59	128.65	3507.0
2008-08-29 04:00:00	QQQ	ETF	46.75	46.75	46.75	46.75	200.0
2008-08-29 04:30:00	QQQ	ETF	46.7	46.7	46.7	46.7	200.0
2008-08-29 07:00:00	QQQ	ETF	46.77	46.82	46.75	46.82	113913.0
2008-08-29 07:30:00	QQQ	ETF	46.8	46.85	46.78	46.83	100788.0
2008-08-29 08:00:00	QQQ	ETF	46.83	46.86	46.82	46.84	966498.0
2008-08-29 08:30:00	QQQ	ETF	46.84	46.85	46.69	46.71	809408.0
2008-08-29 09:00:00	QQQ	ETF	46.71	46.81	46.61	46.61	2270949.0
2008-08-29 09:30:00	QQQ	ETF	46.61	46.75	46.52	46.67	14140210.0
2008-08-29 10:00:00	QQQ	ETF	46.66	46.7	46.38	46.41	12587018.0
2008-08-29 10:30:00	QQQ	ETF	46.41	46.45	46.06	46.09	18654682.0
2008-08-29 11:00:00	QQQ	ETF	46.1	46.2222	46.09	46.11	10542733.0
2008-08-29 11:30:00	QQQ	ETF	46.11	46.13	46.0	46.03	7657935.0
2008-08-29 12:00:00	QQQ	ETF	46.03	46.05	45.92	45.96	7732690.0
2008-08-29 12:30:00	QQQ	ETF	45.95	46.14	45.94	46.12	5379126.0
2008-08-29 13:00:00	QQQ	ETF	46.12	46.35	46.0	46.27	10245203.0
2008-08-29 13:30:00	QQQ	ETF	46.269	46.28	46.14	46.1796	2720657.0
2008-08-29 14:00:00	QQQ	ETF	46.172	46.45	46.17	46.29	4527619.0
2008-08-29 14:30:00	QQQ	ETF	46.3	46.31	46.16	46.28	4456442.0

> showing 50 of 5,713 rows — these rows as CSV

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