PREVIEW / etf_30min / 2016-06-27

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-06-27.parquet
  size:    441 KB
  rows:    15,075

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
2016-06-27 04:00:00	SPY	ETF	202.3	202.5	201.68	201.71	84466.0
2016-06-27 04:30:00	SPY	ETF	201.68	201.86	201.52	201.86	97239.0
2016-06-27 05:00:00	SPY	ETF	201.76	202.14	201.65	201.67	29025.0
2016-06-27 05:30:00	SPY	ETF	201.65	201.65	201.46	201.55	31813.0
2016-06-27 06:00:00	SPY	ETF	201.53	201.6	201.2	201.26	60946.0
2016-06-27 06:30:00	SPY	ETF	201.21	201.26	200.88	200.9	162075.0
2016-06-27 07:00:00	SPY	ETF	200.88	201.2	200.75	200.95	134026.0
2016-06-27 07:30:00	SPY	ETF	200.98	201.02	200.54	200.66	621763.0
2016-06-27 08:00:00	SPY	ETF	200.66	201.32	200.57	201.02	1060105.0
2016-06-27 08:30:00	SPY	ETF	201.02	201.52	200.86	201.41	1245474.0
2016-06-27 09:00:00	SPY	ETF	201.42	201.66	201.29	201.57	1261863.0
2016-06-27 09:30:00	SPY	ETF	201.59	201.6	200.27	200.47	32714204.0
2016-06-27 10:00:00	SPY	ETF	200.46	200.86	199.36	199.48	20970483.0
2016-06-27 10:30:00	SPY	ETF	199.48	199.91	198.71	198.84	22554703.0
2016-06-27 11:00:00	SPY	ETF	198.84	199.42	198.65	199.38	15312703.0
2016-06-27 11:30:00	SPY	ETF	199.38	200.07	199.3	199.75	14685199.0
2016-06-27 12:00:00	SPY	ETF	199.75	200.13	199.54	200.09	8689010.0
2016-06-27 12:30:00	SPY	ETF	200.09	200.17	199.37	199.73	10097927.0
2016-06-27 13:00:00	SPY	ETF	199.74	200.18	199.62	200.01	7336324.0
2016-06-27 13:30:00	SPY	ETF	200.0	200.06	199.19	199.44	8755899.0
2016-06-27 14:00:00	SPY	ETF	199.44	199.6	198.95	199.475	10179572.0
2016-06-27 14:30:00	SPY	ETF	199.5	199.75	198.88	199.02	12859544.0
2016-06-27 15:00:00	SPY	ETF	199.02	199.47	198.66	199.05	13882180.0
2016-06-27 15:30:00	SPY	ETF	199.06	199.9664	198.93	199.59	32214593.0
2016-06-27 16:00:00	SPY	ETF	199.59	199.6341	198.87	199.53	16015636.0
2016-06-27 16:30:00	SPY	ETF	198.98	199.6	198.66	198.72	9383040.0
2016-06-27 17:00:00	SPY	ETF	198.75	198.82	198.67	198.71	792243.0
2016-06-27 17:30:00	SPY	ETF	198.71	198.83	198.7	198.77	68818.0
2016-06-27 18:00:00	SPY	ETF	198.77	199.6	198.77	199.27	1143183.0
2016-06-27 18:30:00	SPY	ETF	199.3	199.45	199.29	199.42	194033.0
2016-06-27 19:00:00	SPY	ETF	199.4	199.57	199.28	199.55	58117.0
2016-06-27 19:30:00	SPY	ETF	199.5	199.59	199.43	199.46	50127.0
2016-06-27 04:00:00	QQQ	ETF	103.93	103.98	103.77	103.77	2433.0
2016-06-27 05:00:00	QQQ	ETF	103.66	103.7	103.45	103.46	6034.0
2016-06-27 05:30:00	QQQ	ETF	103.5	103.5	103.4	103.49	5198.0
2016-06-27 06:00:00	QQQ	ETF	103.45	103.55	103.33	103.33	32051.0
2016-06-27 06:30:00	QQQ	ETF	103.3	103.3	103.15	103.24	24518.0
2016-06-27 07:00:00	QQQ	ETF	103.24	103.32	103.07	103.16	56757.0
2016-06-27 07:30:00	QQQ	ETF	103.18	103.18	102.95	103.03	161287.0
2016-06-27 08:00:00	QQQ	ETF	103.02	103.3	103.0	103.21	73417.0
2016-06-27 08:30:00	QQQ	ETF	103.22	103.43	103.13	103.38	163522.0
2016-06-27 09:00:00	QQQ	ETF	103.38	103.59	103.38	103.59	213892.0
2016-06-27 09:30:00	QQQ	ETF	103.6	103.6	102.81	102.94	4824967.0
2016-06-27 10:00:00	QQQ	ETF	102.94	103.15	102.35	102.4	3663425.0
2016-06-27 10:30:00	QQQ	ETF	102.41	102.605	101.83	101.9	5299225.0
2016-06-27 11:00:00	QQQ	ETF	101.905	102.25	101.77	102.22	3767864.0
2016-06-27 11:30:00	QQQ	ETF	102.22	102.555	102.15	102.34	3068627.0
2016-06-27 12:00:00	QQQ	ETF	102.33	102.6215	102.18	102.61	2584418.0
2016-06-27 12:30:00	QQQ	ETF	102.62	102.672	102.24	102.45	1287201.0
2016-06-27 13:00:00	QQQ	ETF	102.45	102.67	102.34	102.59	1240914.0

> showing 50 of 15,075 rows — these rows as CSV

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