PREVIEW / etf_30min / 2010-06-21

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-06-21.parquet
  size:    266 KB
  rows:    8,773

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
2010-06-21 04:00:00	SPY	ETF	112.99	113.14	112.97	113.14	7095.0
2010-06-21 04:30:00	SPY	ETF	113.14	113.22	113.04	113.2	6470.0
2010-06-21 05:00:00	SPY	ETF	113.12	113.14	113.02	113.12	7100.0
2010-06-21 05:30:00	SPY	ETF	113.07	113.09	112.99	113.02	2800.0
2010-06-21 06:00:00	SPY	ETF	113.11	113.25	113.11	113.23	10100.0
2010-06-21 06:30:00	SPY	ETF	113.23	113.28	113.08	113.09	72491.0
2010-06-21 07:00:00	SPY	ETF	113.12	113.21	113.1	113.14	315763.0
2010-06-21 07:30:00	SPY	ETF	113.15	113.18	113.03	113.06	283732.0
2010-06-21 08:00:00	SPY	ETF	113.03	113.08	111.66	112.78	733615.0
2010-06-21 08:30:00	SPY	ETF	112.78	112.91	112.76	112.86	750736.0
2010-06-21 09:00:00	SPY	ETF	112.85	113.15	112.85	113.11	1416103.0
2010-06-21 09:30:00	SPY	ETF	113.12	113.2	112.61	113.04	26783214.0
2010-06-21 10:00:00	SPY	ETF	113.0383	113.15	112.72	112.72	13634989.0
2010-06-21 10:30:00	SPY	ETF	112.7279	112.85	112.4883	112.52	14170366.0
2010-06-21 11:00:00	SPY	ETF	112.5275	112.77	112.46	112.67	10118322.0
2010-06-21 11:30:00	SPY	ETF	112.67	112.78	112.48	112.57	8423782.0
2010-06-21 12:00:00	SPY	ETF	112.57	112.75	112.22	112.24	10458499.0
2010-06-21 12:30:00	SPY	ETF	112.2398	112.32	112.1	112.28	8752976.0
2010-06-21 13:00:00	SPY	ETF	112.29	112.43	112.19	112.3483	6223598.0
2010-06-21 13:30:00	SPY	ETF	112.35	112.7546	111.93	112.07	9744957.0
2010-06-21 14:00:00	SPY	ETF	112.065	112.42	111.97	112.1797	11124418.0
2010-06-21 14:30:00	SPY	ETF	112.1895	112.27	111.79	111.835	10159714.0
2010-06-21 15:00:00	SPY	ETF	111.83	111.91	110.97	111.12	28051635.0
2010-06-21 15:30:00	SPY	ETF	111.12	111.36	110.79	111.36	34045537.0
2010-06-21 16:00:00	SPY	ETF	111.37	113.1	111.04	111.51	11568248.0
2010-06-21 16:30:00	SPY	ETF	111.51	111.58	111.48	111.53	292969.0
2010-06-21 17:00:00	SPY	ETF	111.56	111.58	111.51	111.52	67484.0
2010-06-21 17:30:00	SPY	ETF	111.57	111.6	111.41	111.57	325757.0
2010-06-21 18:00:00	SPY	ETF	111.57	111.62	111.41	111.56	148843.0
2010-06-21 18:30:00	SPY	ETF	111.57	111.61	111.56	111.58	36410.0
2010-06-21 19:00:00	SPY	ETF	111.58	111.63	111.58	111.61	46198.0
2010-06-21 19:30:00	SPY	ETF	111.62	111.65	111.6	111.6	56351.0
2010-06-21 04:00:00	QQQ	ETF	47.67	47.69	47.63	47.68	19237.0
2010-06-21 04:30:00	QQQ	ETF	47.71	47.71	47.68	47.69	3700.0
2010-06-21 05:00:00	QQQ	ETF	47.65	47.67	47.65	47.67	2000.0
2010-06-21 05:30:00	QQQ	ETF	47.65	47.67	47.65	47.67	1350.0
2010-06-21 06:00:00	QQQ	ETF	47.65	47.71	47.65	47.71	2850.0
2010-06-21 06:30:00	QQQ	ETF	47.68	47.68	47.63	47.63	5200.0
2010-06-21 07:00:00	QQQ	ETF	47.65	47.67	47.63	47.64	57077.0
2010-06-21 07:30:00	QQQ	ETF	47.64	47.65	47.56	47.56	243572.0
2010-06-21 08:00:00	QQQ	ETF	47.6	47.6	47.45	47.45	1388642.0
2010-06-21 08:30:00	QQQ	ETF	47.45	47.55	47.45	47.55	338335.0
2010-06-21 09:00:00	QQQ	ETF	47.54	47.62	47.54	47.6	1074699.0
2010-06-21 09:30:00	QQQ	ETF	47.6	47.66	47.36	47.63	11893861.0
2010-06-21 10:00:00	QQQ	ETF	47.63	47.68	47.4	47.4	5279886.0
2010-06-21 10:30:00	QQQ	ETF	47.4	47.44	47.23	47.27	4374549.0
2010-06-21 11:00:00	QQQ	ETF	47.27	47.42	47.23	47.33	4339177.0
2010-06-21 11:30:00	QQQ	ETF	47.32	47.36	47.17	47.23	3723535.0
2010-06-21 12:00:00	QQQ	ETF	47.22	47.27	47.06	47.07	3613942.0
2010-06-21 12:30:00	QQQ	ETF	47.07	47.177	47.04	47.17	2914970.0

> showing 50 of 8,773 rows — these rows as CSV

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