PREVIEW / etf_30min / 2016-01-19

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-01-19.parquet
  size:    426 KB
  rows:    14,391

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-01-19 04:00:00	SPY	ETF	190.48	190.73	190.0	190.73	74646.0
2016-01-19 04:30:00	SPY	ETF	190.79	191.0	190.45	190.68	23097.0
2016-01-19 05:00:00	SPY	ETF	190.73	191.03	190.65	190.7	36109.0
2016-01-19 05:30:00	SPY	ETF	190.78	191.06	190.76	190.92	33691.0
2016-01-19 06:00:00	SPY	ETF	190.94	191.1	190.9	190.99	58541.0
2016-01-19 06:30:00	SPY	ETF	190.99	191.29	190.99	191.23	135701.0
2016-01-19 07:00:00	SPY	ETF	191.23	191.23	190.8	190.87	264124.0
2016-01-19 07:30:00	SPY	ETF	190.83	191.12	190.61	190.74	463130.0
2016-01-19 08:00:00	SPY	ETF	190.74	191.14	187.3	190.55	3830728.0
2016-01-19 08:30:00	SPY	ETF	190.56	190.77	190.43	190.6	511570.0
2016-01-19 09:00:00	SPY	ETF	190.6	190.63	187.8617	189.95	2732695.0
2016-01-19 09:30:00	SPY	ETF	189.96	190.11	188.34	189.05	20817909.0
2016-01-19 10:00:00	SPY	ETF	189.05	189.86	188.77	189.8	13336783.0
2016-01-19 10:30:00	SPY	ETF	189.8	189.99	188.71	188.71	9649655.0
2016-01-19 11:00:00	SPY	ETF	188.7101	189.1	188.15	189.0	12166720.0
2016-01-19 11:30:00	SPY	ETF	189.02	189.47	188.85	188.9	13746642.0
2016-01-19 12:00:00	SPY	ETF	188.9	188.96	187.88	188.3001	11649603.0
2016-01-19 12:30:00	SPY	ETF	188.3	188.72	187.87	188.2276	8483765.0
2016-01-19 13:00:00	SPY	ETF	188.22	188.59	187.91	187.96	6690971.0
2016-01-19 13:30:00	SPY	ETF	187.97	188.33	187.69	187.83	7833500.0
2016-01-19 14:00:00	SPY	ETF	187.835	187.96	186.52	187.05	14215553.0
2016-01-19 14:30:00	SPY	ETF	187.05	187.19	186.2	186.69	10999111.0
2016-01-19 15:00:00	SPY	ETF	186.69	188.04	186.51	188.0	13797807.0
2016-01-19 15:30:00	SPY	ETF	188.0	188.74	187.725	188.02	21065008.0
2016-01-19 16:00:00	SPY	ETF	188.02	188.25	187.4804	187.99	9490751.0
2016-01-19 16:30:00	SPY	ETF	188.0	188.19	187.65	187.73	575835.0
2016-01-19 17:00:00	SPY	ETF	187.76	188.06	187.51	187.59	142529.0
2016-01-19 17:30:00	SPY	ETF	187.59	187.7	187.53	187.67	1067069.0
2016-01-19 18:00:00	SPY	ETF	187.68	188.15	187.63	187.96	242508.0
2016-01-19 18:30:00	SPY	ETF	187.95	188.34	187.92	188.2	177420.0
2016-01-19 19:00:00	SPY	ETF	188.1	188.11	186.91	187.29	222990.0
2016-01-19 19:30:00	SPY	ETF	187.26	187.65	187.21	187.28	90384.0
2016-01-19 04:00:00	QQQ	ETF	102.33	102.6	102.31	102.6	2447.0
2016-01-19 04:30:00	QQQ	ETF	102.66	102.73	102.66	102.7	5700.0
2016-01-19 05:00:00	QQQ	ETF	102.64	102.77	102.6	102.6	3600.0
2016-01-19 05:30:00	QQQ	ETF	102.75	102.75	102.65	102.65	500.0
2016-01-19 06:00:00	QQQ	ETF	102.7	102.8	102.7	102.76	9250.0
2016-01-19 06:30:00	QQQ	ETF	102.75	102.86	102.75	102.85	18550.0
2016-01-19 07:00:00	QQQ	ETF	102.8	102.84	102.63	102.63	22721.0
2016-01-19 07:30:00	QQQ	ETF	102.6	102.76	102.54	102.62	13072.0
2016-01-19 08:00:00	QQQ	ETF	102.59	102.8001	102.34	102.44	164137.0
2016-01-19 08:30:00	QQQ	ETF	102.45	102.6	102.41	102.48	278700.0
2016-01-19 09:00:00	QQQ	ETF	102.49	102.49	102.15	102.19	685896.0
2016-01-19 09:30:00	QQQ	ETF	102.2	102.37	101.4	101.74	7135869.0
2016-01-19 10:00:00	QQQ	ETF	101.73	102.14	101.57	102.11	5082442.0
2016-01-19 10:30:00	QQQ	ETF	102.11	102.26	101.53	101.53	3291700.0
2016-01-19 11:00:00	QQQ	ETF	101.53	101.76	100.98	101.46	4954865.0
2016-01-19 11:30:00	QQQ	ETF	101.47	101.78	101.32	101.425	2866851.0
2016-01-19 12:00:00	QQQ	ETF	101.42	101.46	100.86	101.11	2311933.0
2016-01-19 12:30:00	QQQ	ETF	101.11	101.39	100.84	101.11	2002711.0

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

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