PREVIEW / etf_30min / 2015-08-27

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-08-27.parquet
  size:    421 KB
  rows:    14,218

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-08-27 04:00:00	SPY	ETF	196.32	196.58	196.07	196.58	67374.0
2015-08-27 04:30:00	SPY	ETF	196.6	197.11	196.34	197.11	198071.0
2015-08-27 05:00:00	SPY	ETF	197.18	197.18	196.72	196.86	145996.0
2015-08-27 05:30:00	SPY	ETF	196.83	196.87	196.46	196.63	62341.0
2015-08-27 06:00:00	SPY	ETF	196.79	197.07	196.68	196.7	52106.0
2015-08-27 06:30:00	SPY	ETF	196.67	196.84	196.42	196.42	223006.0
2015-08-27 07:00:00	SPY	ETF	196.45	196.56	196.0	196.32	534387.0
2015-08-27 07:30:00	SPY	ETF	196.28	196.56	196.04	196.04	666956.0
2015-08-27 08:00:00	SPY	ETF	196.04	196.54	195.79	196.33	1144759.0
2015-08-27 08:30:00	SPY	ETF	196.35	197.09	196.13	196.9	2281308.0
2015-08-27 09:00:00	SPY	ETF	196.9	197.13	196.68	197.01	2224970.0
2015-08-27 09:30:00	SPY	ETF	197.02	197.64	196.54	196.8	28706504.0
2015-08-27 10:00:00	SPY	ETF	196.82	197.43	196.37	197.17	16855400.0
2015-08-27 10:30:00	SPY	ETF	197.16	198.13	196.774	198.07	16838206.0
2015-08-27 11:00:00	SPY	ETF	198.06	198.5	197.92	198.0749	15203702.0
2015-08-27 11:30:00	SPY	ETF	198.08	198.23	197.58	198.11	10677816.0
2015-08-27 12:00:00	SPY	ETF	198.1099	198.92	198.06	198.79	9808598.0
2015-08-27 12:30:00	SPY	ETF	198.79	199.24	198.53	199.19	9124931.0
2015-08-27 13:00:00	SPY	ETF	199.18	199.41	198.92	199.04	9022709.0
2015-08-27 13:30:00	SPY	ETF	199.035	199.23	198.57	199.17	9966811.0
2015-08-27 14:00:00	SPY	ETF	199.17	199.18	197.4	197.65	16446860.0
2015-08-27 14:30:00	SPY	ETF	197.66	198.19	196.06	196.185	24929260.0
2015-08-27 15:00:00	SPY	ETF	196.18	197.41	195.21	197.37	39679272.0
2015-08-27 15:30:00	SPY	ETF	197.36	199.32	196.99	199.28	43377475.0
2015-08-27 16:00:00	SPY	ETF	199.3	199.77	197.035	199.63	9526913.0
2015-08-27 16:30:00	SPY	ETF	199.63	199.69	199.27	199.63	3682670.0
2015-08-27 17:00:00	SPY	ETF	199.63	199.7	199.55	199.61	1194287.0
2015-08-27 17:30:00	SPY	ETF	199.61	199.72	199.55	199.55	85122.0
2015-08-27 18:00:00	SPY	ETF	199.57	199.61	197.6831	199.5	194441.0
2015-08-27 18:30:00	SPY	ETF	199.48	199.48	199.36	199.41	71435.0
2015-08-27 19:00:00	SPY	ETF	199.43	199.49	199.39	199.47	69000.0
2015-08-27 19:30:00	SPY	ETF	199.41	199.66	199.31	199.66	52484.0
2015-08-27 04:00:00	QQQ	ETF	104.0	104.16	103.85	104.16	12029.0
2015-08-27 04:30:00	QQQ	ETF	104.17	104.49	104.01	104.49	12300.0
2015-08-27 05:00:00	QQQ	ETF	104.63	104.67	104.2	104.67	870.0
2015-08-27 05:30:00	QQQ	ETF	104.4	104.44	104.32	104.32	1100.0
2015-08-27 06:00:00	QQQ	ETF	104.41	104.62	104.25	104.25	20376.0
2015-08-27 06:30:00	QQQ	ETF	104.25	104.42	104.24	104.24	11500.0
2015-08-27 07:00:00	QQQ	ETF	104.25	104.32	104.01	104.14	45943.0
2015-08-27 07:30:00	QQQ	ETF	104.14	104.3	104.0	104.06	51046.0
2015-08-27 08:00:00	QQQ	ETF	104.04	104.24	103.87	104.07	114573.0
2015-08-27 08:30:00	QQQ	ETF	104.09	104.49	104.04	104.37	355044.0
2015-08-27 09:00:00	QQQ	ETF	104.39	104.74	104.24	104.51	362889.0
2015-08-27 09:30:00	QQQ	ETF	104.52	105.05	104.19	104.4	7145862.0
2015-08-27 10:00:00	QQQ	ETF	104.39	104.91	104.1001	104.64	3809191.0
2015-08-27 10:30:00	QQQ	ETF	104.66	105.08	104.395	105.04	4052939.0
2015-08-27 11:00:00	QQQ	ETF	105.045	105.35	104.95	105.077	4404068.0
2015-08-27 11:30:00	QQQ	ETF	105.09	105.13	104.67	104.96	3055558.0
2015-08-27 12:00:00	QQQ	ETF	104.97	105.52	104.925	105.51	2976113.0
2015-08-27 12:30:00	QQQ	ETF	105.505	105.67	105.29	105.61	1949255.0

> showing 50 of 14,218 rows — these rows as CSV

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