PREVIEW / etf_30min / 2015-09-30

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-09-30.parquet
  size:    391 KB
  rows:    13,365

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-09-30 04:00:00	SPY	ETF	189.58	190.0	189.53	190.0	12195.0
2015-09-30 04:30:00	SPY	ETF	190.0	190.35	190.0	190.27	119578.0
2015-09-30 05:00:00	SPY	ETF	190.25	190.51	190.25	190.39	22388.0
2015-09-30 05:30:00	SPY	ETF	190.4	190.52	190.31	190.42	11591.0
2015-09-30 06:00:00	SPY	ETF	190.47	190.59	190.35	190.53	41460.0
2015-09-30 06:30:00	SPY	ETF	190.57	190.65	190.45	190.5	63263.0
2015-09-30 07:00:00	SPY	ETF	190.54	190.78	190.53	190.75	405856.0
2015-09-30 07:30:00	SPY	ETF	190.7	190.72	190.34	190.39	290756.0
2015-09-30 08:00:00	SPY	ETF	190.38	190.67	189.25	190.52	1131121.0
2015-09-30 08:30:00	SPY	ETF	190.5	190.5	190.18	190.35	576997.0
2015-09-30 09:00:00	SPY	ETF	190.35	190.41	190.13	190.38	863563.0
2015-09-30 09:30:00	SPY	ETF	190.37	191.21	190.22	190.55	16189726.0
2015-09-30 10:00:00	SPY	ETF	190.539	191.33	190.46	191.3	10049261.0
2015-09-30 10:30:00	SPY	ETF	191.29	191.47	190.84	190.975	9844800.0
2015-09-30 11:00:00	SPY	ETF	190.975	191.16	190.68	191.02	5367278.0
2015-09-30 11:30:00	SPY	ETF	191.02	191.13	190.24	190.4696	7112898.0
2015-09-30 12:00:00	SPY	ETF	190.47	190.571	189.8	190.11	8149489.0
2015-09-30 12:30:00	SPY	ETF	190.11	190.24	189.44	189.7599	8452043.0
2015-09-30 13:00:00	SPY	ETF	189.76	190.43	189.73	190.32	5503117.0
2015-09-30 13:30:00	SPY	ETF	190.32	190.9731	190.1	190.845	5966915.0
2015-09-30 14:00:00	SPY	ETF	190.85	190.95	190.43	190.94	6418594.0
2015-09-30 14:30:00	SPY	ETF	190.94	191.18	190.401	191.12	8285892.0
2015-09-30 15:00:00	SPY	ETF	191.1	191.29	190.69	191.16	14372528.0
2015-09-30 15:30:00	SPY	ETF	191.1601	191.825	191.11	191.67	31685188.0
2015-09-30 16:00:00	SPY	ETF	191.67	191.7906	190.9541	191.12	12822445.0
2015-09-30 16:30:00	SPY	ETF	191.11	191.63	190.95	191.07	6788940.0
2015-09-30 17:00:00	SPY	ETF	191.06	191.06	190.98	191.0	421019.0
2015-09-30 17:30:00	SPY	ETF	191.0	191.05	190.98	191.03	143221.0
2015-09-30 18:00:00	SPY	ETF	191.0	191.2	190.97	191.18	168217.0
2015-09-30 18:30:00	SPY	ETF	191.18	191.24	191.07	191.2	267962.0
2015-09-30 19:00:00	SPY	ETF	191.17	191.25	191.16	191.17	76097.0
2015-09-30 19:30:00	SPY	ETF	191.2	191.25	191.17	191.21	21957.0
2015-09-30 04:00:00	QQQ	ETF	100.33	100.58	100.33	100.58	3984.0
2015-09-30 04:30:00	QQQ	ETF	100.63	100.75	100.6	100.7	4800.0
2015-09-30 05:00:00	QQQ	ETF	100.77	100.84	100.75	100.77	6800.0
2015-09-30 05:30:00	QQQ	ETF	100.77	100.83	100.72	100.79	8900.0
2015-09-30 06:00:00	QQQ	ETF	100.84	100.85	100.79	100.84	5600.0
2015-09-30 06:30:00	QQQ	ETF	100.86	100.94	100.84	100.88	10350.0
2015-09-30 07:00:00	QQQ	ETF	100.87	101.05	100.87	101.05	72410.0
2015-09-30 07:30:00	QQQ	ETF	101.06	101.1	100.88	100.88	28473.0
2015-09-30 08:00:00	QQQ	ETF	100.89	101.1	100.88	101.0	111107.0
2015-09-30 08:30:00	QQQ	ETF	101.0	101.0	100.81	100.9	214892.0
2015-09-30 09:00:00	QQQ	ETF	100.92	101.0	100.78	100.88	265809.0
2015-09-30 09:30:00	QQQ	ETF	100.89	101.4625	100.78	101.01	6141482.0
2015-09-30 10:00:00	QQQ	ETF	101.01	101.75	100.96	101.75	3351277.0
2015-09-30 10:30:00	QQQ	ETF	101.74	101.87	101.42	101.49	2852609.0
2015-09-30 11:00:00	QQQ	ETF	101.49	101.58	101.31	101.49	1886809.0
2015-09-30 11:30:00	QQQ	ETF	101.49	101.54	100.99	101.19	1945332.0
2015-09-30 12:00:00	QQQ	ETF	101.19	101.27	100.69	100.93	1692878.0
2015-09-30 12:30:00	QQQ	ETF	100.93	101.0228	100.5	100.7101	2002267.0

> showing 50 of 13,365 rows — these rows as CSV

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