PREVIEW / etf_30min / 2015-06-05

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-06-05.parquet
  size:    376 KB
  rows:    12,661

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
2015-06-05 04:00:00	SPY	ETF	210.57	210.63	210.4	210.62	6285.0
2015-06-05 04:30:00	SPY	ETF	210.72	210.77	210.41	210.41	28941.0
2015-06-05 05:00:00	SPY	ETF	210.41	210.55	210.41	210.47	4158.0
2015-06-05 05:30:00	SPY	ETF	210.46	210.51	210.35	210.35	7997.0
2015-06-05 06:00:00	SPY	ETF	210.32	210.35	209.88	209.9	294692.0
2015-06-05 06:30:00	SPY	ETF	209.9	209.99	209.77	209.95	203705.0
2015-06-05 07:00:00	SPY	ETF	209.98	210.14	209.85	210.1	103809.0
2015-06-05 07:30:00	SPY	ETF	210.15	210.32	210.05	210.2	180404.0
2015-06-05 08:00:00	SPY	ETF	210.2	210.36	209.91	210.17	411515.0
2015-06-05 08:30:00	SPY	ETF	210.23	210.28	209.28	209.91	4943683.0
2015-06-05 09:00:00	SPY	ETF	209.89	210.13	209.69	209.94	1072853.0
2015-06-05 09:30:00	SPY	ETF	209.95	210.17	208.98	209.6801	18993117.0
2015-06-05 10:00:00	SPY	ETF	209.7	210.41	209.66	210.22	13247245.0
2015-06-05 10:30:00	SPY	ETF	210.22	210.58	209.79	209.955	9296333.0
2015-06-05 11:00:00	SPY	ETF	209.955	210.22	209.86	210.07	5091155.0
2015-06-05 11:30:00	SPY	ETF	210.08	210.15	209.79	209.97	5609459.0
2015-06-05 12:00:00	SPY	ETF	209.96	209.98	209.6	209.6254	5521920.0
2015-06-05 12:30:00	SPY	ETF	209.6235	210.07	209.47	210.01	5349908.0
2015-06-05 13:00:00	SPY	ETF	210.005	210.07	209.82	210.02	4672141.0
2015-06-05 13:30:00	SPY	ETF	210.0	210.15	209.81	209.87	3255957.0
2015-06-05 14:00:00	SPY	ETF	209.88	210.17	209.86	209.97	3215490.0
2015-06-05 14:30:00	SPY	ETF	209.96	210.12	209.8	209.95	4043781.0
2015-06-05 15:00:00	SPY	ETF	209.94	210.085	209.68	209.75	4602513.0
2015-06-05 15:30:00	SPY	ETF	209.76	209.94	209.56	209.79	14307769.0
2015-06-05 16:00:00	SPY	ETF	209.78	209.89	209.65	209.82	9226125.0
2015-06-05 16:30:00	SPY	ETF	209.82	209.88	209.76	209.83	6319192.0
2015-06-05 17:00:00	SPY	ETF	209.83	209.83	209.72	209.8	334311.0
2015-06-05 17:30:00	SPY	ETF	209.81	209.83	209.75	209.75	16527.0
2015-06-05 18:00:00	SPY	ETF	209.76	209.81	209.76	209.8	10312.0
2015-06-05 18:30:00	SPY	ETF	209.8	209.81	209.77	209.77	3677.0
2015-06-05 19:00:00	SPY	ETF	209.79	209.8	209.77	209.8	4024.0
2015-06-05 19:30:00	SPY	ETF	209.81	209.82	209.77	209.82	3931.0
2015-06-05 06:00:00	QQQ	ETF	109.47	109.47	109.39	109.45	20400.0
2015-06-05 06:30:00	QQQ	ETF	109.43	109.51	109.42	109.49	9998.0
2015-06-05 07:00:00	QQQ	ETF	109.48	109.57	109.45	109.57	18300.0
2015-06-05 07:30:00	QQQ	ETF	109.58	109.66	109.58	109.64	12000.0
2015-06-05 08:00:00	QQQ	ETF	109.61	109.65	109.47	109.53	80600.0
2015-06-05 08:30:00	QQQ	ETF	109.53	109.59	109.09	109.39	407458.0
2015-06-05 09:00:00	QQQ	ETF	109.38	109.52	109.29	109.42	279684.0
2015-06-05 09:30:00	QQQ	ETF	109.42	109.61	108.63	109.04	5456012.0
2015-06-05 10:00:00	QQQ	ETF	109.06	109.56	109.04	109.4	2748129.0
2015-06-05 10:30:00	QQQ	ETF	109.4045	109.69	109.24	109.36	1937635.0
2015-06-05 11:00:00	QQQ	ETF	109.36	109.6	109.31	109.52	793411.0
2015-06-05 11:30:00	QQQ	ETF	109.52	109.565	109.295	109.45	738834.0
2015-06-05 12:00:00	QQQ	ETF	109.45	109.46	109.2	109.2401	723385.0
2015-06-05 12:30:00	QQQ	ETF	109.2444	109.435	109.15	109.41	824948.0
2015-06-05 13:00:00	QQQ	ETF	109.41	109.44	109.32	109.42	588502.0
2015-06-05 13:30:00	QQQ	ETF	109.42	109.515	109.34	109.38	589503.0
2015-06-05 14:00:00	QQQ	ETF	109.38	109.57	109.38	109.47	668907.0
2015-06-05 14:30:00	QQQ	ETF	109.46	109.515	109.36	109.44	1063176.0

> showing 50 of 12,661 rows — these rows as CSV

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