PREVIEW / etf_30min / 2016-12-09

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-12-09.parquet
  size:    440 KB
  rows:    14,892

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-12-09 04:00:00	SPY	ETF	225.15	225.28	225.07	225.27	5150.0
2016-12-09 04:30:00	SPY	ETF	225.24	225.27	225.1	225.1	6000.0
2016-12-09 05:00:00	SPY	ETF	225.17	225.22	225.16	225.19	3700.0
2016-12-09 05:30:00	SPY	ETF	225.19	225.28	225.18	225.28	10900.0
2016-12-09 06:00:00	SPY	ETF	225.27	225.36	225.27	225.36	16876.0
2016-12-09 06:30:00	SPY	ETF	225.33	225.43	225.33	225.41	43057.0
2016-12-09 07:00:00	SPY	ETF	225.43	225.46	225.38	225.43	55797.0
2016-12-09 07:30:00	SPY	ETF	225.38	225.46	225.35	225.46	56880.0
2016-12-09 08:00:00	SPY	ETF	225.44	225.47	225.28	225.3	173005.0
2016-12-09 08:30:00	SPY	ETF	225.29	225.61	225.29	225.58	414607.0
2016-12-09 09:00:00	SPY	ETF	225.59	225.64	225.39	225.42	380705.0
2016-12-09 09:30:00	SPY	ETF	225.41	225.8507	225.37	225.74	8683215.0
2016-12-09 10:00:00	SPY	ETF	225.75	225.805	225.48	225.7	5749218.0
2016-12-09 10:30:00	SPY	ETF	225.69	226.015	225.69	225.804	7250437.0
2016-12-09 11:00:00	SPY	ETF	225.81	225.94	225.63	225.7	3808201.0
2016-12-09 11:30:00	SPY	ETF	225.71	225.89	225.6	225.735	4044822.0
2016-12-09 12:00:00	SPY	ETF	225.74	225.85	225.67	225.8393	3886639.0
2016-12-09 12:30:00	SPY	ETF	225.835	225.99	225.79	225.85	2979840.0
2016-12-09 13:00:00	SPY	ETF	225.86	225.9	225.735	225.84	2653277.0
2016-12-09 13:30:00	SPY	ETF	225.84	225.98	225.79	225.915	2474650.0
2016-12-09 14:00:00	SPY	ETF	225.92	226.06	225.88	225.89	3311977.0
2016-12-09 14:30:00	SPY	ETF	225.88	226.07	225.85	226.065	3580092.0
2016-12-09 15:00:00	SPY	ETF	226.07	226.5	226.02	226.4467	8501653.0
2016-12-09 15:30:00	SPY	ETF	226.44	226.5	226.26	226.49	17172698.0
2016-12-09 16:00:00	SPY	ETF	226.5	226.61	226.44	226.51	8310017.0
2016-12-09 16:30:00	SPY	ETF	226.52	226.63	226.51	226.63	2459432.0
2016-12-09 17:00:00	SPY	ETF	226.61	226.7	226.51	226.65	317014.0
2016-12-09 17:30:00	SPY	ETF	226.64	226.75	226.58	226.69	109761.0
2016-12-09 18:00:00	SPY	ETF	226.69	226.7	226.66	226.7	39781.0
2016-12-09 18:30:00	SPY	ETF	226.68	226.72	226.63	226.68	20669.0
2016-12-09 19:00:00	SPY	ETF	226.65	226.67	226.63	226.65	11187.0
2016-12-09 19:30:00	SPY	ETF	226.65	226.66	226.65	226.65	17364.0
2016-12-09 04:30:00	QQQ	ETF	118.64	118.64	118.64	118.64	416.0
2016-12-09 05:00:00	QQQ	ETF	118.63	118.66	118.63	118.66	1350.0
2016-12-09 05:30:00	QQQ	ETF	118.77	118.79	118.77	118.79	1600.0
2016-12-09 06:00:00	QQQ	ETF	118.79	118.83	118.79	118.83	4100.0
2016-12-09 06:30:00	QQQ	ETF	118.86	118.86	118.86	118.86	1000.0
2016-12-09 07:00:00	QQQ	ETF	118.87	118.87	118.84	118.84	3310.0
2016-12-09 07:30:00	QQQ	ETF	118.85	118.85	118.85	118.85	100.0
2016-12-09 08:00:00	QQQ	ETF	118.9	118.93	118.88	118.92	27274.0
2016-12-09 08:30:00	QQQ	ETF	118.9	119.07	118.9	119.07	142737.0
2016-12-09 09:00:00	QQQ	ETF	119.08	119.14	119.02	119.02	155541.0
2016-12-09 09:30:00	QQQ	ETF	119.03	119.43	119.0	119.4	3657840.0
2016-12-09 10:00:00	QQQ	ETF	119.41	119.43	119.1	119.29	1386927.0
2016-12-09 10:30:00	QQQ	ETF	119.281	119.5402	119.25	119.26	1188846.0
2016-12-09 11:00:00	QQQ	ETF	119.26	119.48	119.2436	119.38	690867.0
2016-12-09 11:30:00	QQQ	ETF	119.38	119.451	119.3	119.4	1130258.0
2016-12-09 12:00:00	QQQ	ETF	119.4	119.44	119.24	119.3	843801.0
2016-12-09 12:30:00	QQQ	ETF	119.3	119.41	119.22	119.24	946845.0
2016-12-09 13:00:00	QQQ	ETF	119.25	119.3	119.1	119.23	698835.0

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

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