PREVIEW / etf_30min / 2017-01-06

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-01-06.parquet
  size:    434 KB
  rows:    14,741

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
2017-01-06 04:00:00	SPY	ETF	226.35	226.35	226.32	226.35	2725.0
2017-01-06 04:30:00	SPY	ETF	226.35	226.35	226.27	226.27	3102.0
2017-01-06 05:00:00	SPY	ETF	226.3	226.43	226.3	226.43	4704.0
2017-01-06 05:30:00	SPY	ETF	226.4	226.4	226.35	226.4	9927.0
2017-01-06 06:00:00	SPY	ETF	226.4	226.4	226.4	226.4	1000.0
2017-01-06 06:30:00	SPY	ETF	226.38	226.43	226.38	226.43	1003.0
2017-01-06 07:00:00	SPY	ETF	226.43	226.48	226.4	226.4	5607.0
2017-01-06 07:30:00	SPY	ETF	226.37	226.37	226.23	226.28	108406.0
2017-01-06 08:00:00	SPY	ETF	226.33	226.44	226.23	226.34	267495.0
2017-01-06 08:30:00	SPY	ETF	226.42	226.72	226.25	226.7	558421.0
2017-01-06 09:00:00	SPY	ETF	226.71	226.72	226.52	226.52	179295.0
2017-01-06 09:30:00	SPY	ETF	226.53	226.665	225.9	226.42	5840999.0
2017-01-06 10:00:00	SPY	ETF	226.413	226.6644	226.34	226.5	4003071.0
2017-01-06 10:30:00	SPY	ETF	226.5	226.725	226.17	226.59	3615270.0
2017-01-06 11:00:00	SPY	ETF	226.58	227.01	226.53	226.97	3981733.0
2017-01-06 11:30:00	SPY	ETF	226.97	227.43	226.92	227.2962	4438620.0
2017-01-06 12:00:00	SPY	ETF	227.3	227.47	227.19	227.4659	3013018.0
2017-01-06 12:30:00	SPY	ETF	227.46	227.74	227.46	227.635	4791171.0
2017-01-06 13:00:00	SPY	ETF	227.64	227.68	227.37	227.39	2814614.0
2017-01-06 13:30:00	SPY	ETF	227.38	227.67	227.37	227.52	2991390.0
2017-01-06 14:00:00	SPY	ETF	227.52	227.75	227.45	227.505	5872973.0
2017-01-06 14:30:00	SPY	ETF	227.505	227.59	227.38	227.41	4140054.0
2017-01-06 15:00:00	SPY	ETF	227.41	227.58	227.36	227.37	4536311.0
2017-01-06 15:30:00	SPY	ETF	227.37	227.58	227.17	227.24	11558230.0
2017-01-06 16:00:00	SPY	ETF	227.23	227.34	227.16	227.22	6149879.0
2017-01-06 16:30:00	SPY	ETF	227.21	227.59	227.13	227.15	1017877.0
2017-01-06 17:00:00	SPY	ETF	227.14	227.18	227.11	227.16	53365.0
2017-01-06 17:30:00	SPY	ETF	227.18	227.19	227.12	227.12	14417.0
2017-01-06 18:00:00	SPY	ETF	227.11	227.11	227.01	227.07	41006.0
2017-01-06 18:30:00	SPY	ETF	227.03	227.03	226.8	226.83	66317.0
2017-01-06 19:00:00	SPY	ETF	226.83	226.9	226.77	226.83	42394.0
2017-01-06 19:30:00	SPY	ETF	226.83	226.85	226.7	226.79	39144.0
2017-01-06 04:30:00	QQQ	ETF	120.86	120.86	120.86	120.86	999.0
2017-01-06 05:00:00	QQQ	ETF	120.88	120.88	120.88	120.88	600.0
2017-01-06 06:00:00	QQQ	ETF	120.9	120.91	120.9	120.91	200.0
2017-01-06 06:30:00	QQQ	ETF	120.92	120.92	120.92	120.92	300.0
2017-01-06 07:00:00	QQQ	ETF	120.98	120.99	120.98	120.99	238.0
2017-01-06 07:30:00	QQQ	ETF	120.94	120.94	120.88	120.88	13900.0
2017-01-06 08:00:00	QQQ	ETF	120.9	120.95	120.87	120.95	26856.0
2017-01-06 08:30:00	QQQ	ETF	120.92	121.1	120.92	121.06	140967.0
2017-01-06 09:00:00	QQQ	ETF	121.01	121.05	120.98	121.01	77652.0
2017-01-06 09:30:00	QQQ	ETF	120.99	121.3	120.685	121.28	2231205.0
2017-01-06 10:00:00	QQQ	ETF	121.28	121.41	121.15	121.26	1468714.0
2017-01-06 10:30:00	QQQ	ETF	121.27	121.58	121.115	121.49	1452842.0
2017-01-06 11:00:00	QQQ	ETF	121.49	121.68	121.45	121.62	1291990.0
2017-01-06 11:30:00	QQQ	ETF	121.63	121.89	121.58	121.861	2134231.0
2017-01-06 12:00:00	QQQ	ETF	121.85	122.03	121.82	122.011	1012378.0
2017-01-06 12:30:00	QQQ	ETF	122.0135	122.16	122.0	122.12	1207387.0
2017-01-06 13:00:00	QQQ	ETF	122.115	122.16	121.94	121.965	752172.0
2017-01-06 13:30:00	QQQ	ETF	121.955	122.15	121.94	122.075	734835.0

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

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