PREVIEW / etf_30min / 2017-06-09

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-06-09.parquet
  size:    443 KB
  rows:    15,121

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-06-09 04:00:00	SPY	ETF	243.84	243.9	243.83	243.83	4250.0
2017-06-09 04:30:00	SPY	ETF	243.8	244.08	243.8	244.08	7450.0
2017-06-09 05:00:00	SPY	ETF	244.09	244.13	244.03	244.13	2500.0
2017-06-09 05:30:00	SPY	ETF	244.07	244.07	243.99	244.04	9100.0
2017-06-09 06:00:00	SPY	ETF	244.03	244.04	244.0	244.03	7030.0
2017-06-09 06:30:00	SPY	ETF	244.05	244.05	243.84	243.84	33203.0
2017-06-09 07:00:00	SPY	ETF	243.87	243.93	243.8	243.85	68067.0
2017-06-09 07:30:00	SPY	ETF	243.85	244.12	243.85	244.07	81912.0
2017-06-09 08:00:00	SPY	ETF	244.06	244.13	243.8	243.96	151388.0
2017-06-09 08:30:00	SPY	ETF	243.97	244.06	243.96	243.97	78169.0
2017-06-09 09:00:00	SPY	ETF	243.97	244.15	243.91	244.11	479398.0
2017-06-09 09:30:00	SPY	ETF	244.09	244.6	244.03	244.47	7109381.0
2017-06-09 10:00:00	SPY	ETF	244.475	244.92	244.4	244.9	6614028.0
2017-06-09 10:30:00	SPY	ETF	244.9	245.01	244.8	244.83	4572994.0
2017-06-09 11:00:00	SPY	ETF	244.835	244.99	244.68	244.83	5436144.0
2017-06-09 11:30:00	SPY	ETF	244.8399	244.92	244.68	244.69	3764591.0
2017-06-09 12:00:00	SPY	ETF	244.69	244.78	244.17	244.315	4516056.0
2017-06-09 12:30:00	SPY	ETF	244.3173	244.36	243.95	244.275	5725928.0
2017-06-09 13:00:00	SPY	ETF	244.27	244.39	243.74	244.04	6410151.0
2017-06-09 13:30:00	SPY	ETF	244.04	244.055	243.28	243.285	8658950.0
2017-06-09 14:00:00	SPY	ETF	243.28	243.75	243.25	243.4282	8081578.0
2017-06-09 14:30:00	SPY	ETF	243.43	243.55	241.95	242.465	15988528.0
2017-06-09 15:00:00	SPY	ETF	242.46	243.63	242.43	243.4856	12855856.0
2017-06-09 15:30:00	SPY	ETF	243.48	243.59	242.735	243.45	25125331.0
2017-06-09 16:00:00	SPY	ETF	243.45	243.58	242.9522	243.54	11809277.0
2017-06-09 16:30:00	SPY	ETF	243.53	243.58	243.48	243.48	3157981.0
2017-06-09 17:00:00	SPY	ETF	243.51	243.54	243.41	243.46	535850.0
2017-06-09 17:30:00	SPY	ETF	243.5	243.56	243.43	243.55	101872.0
2017-06-09 18:00:00	SPY	ETF	243.55	243.6	243.55	243.59	24204.0
2017-06-09 18:30:00	SPY	ETF	243.57	243.59	243.55	243.55	4874.0
2017-06-09 19:00:00	SPY	ETF	243.58	243.58	243.55	243.56	7398.0
2017-06-09 19:30:00	SPY	ETF	243.57	243.59	243.57	243.59	22130.0
2017-06-09 04:00:00	QQQ	ETF	143.5	143.68	143.46	143.68	2700.0
2017-06-09 04:30:00	QQQ	ETF	143.78	143.78	143.78	143.78	1352.0
2017-06-09 05:00:00	QQQ	ETF	143.75	143.75	143.69	143.75	3100.0
2017-06-09 05:30:00	QQQ	ETF	143.75	143.75	143.72	143.72	600.0
2017-06-09 06:30:00	QQQ	ETF	143.69	143.7	143.6	143.62	23900.0
2017-06-09 07:00:00	QQQ	ETF	143.62	143.62	143.54	143.57	13675.0
2017-06-09 07:30:00	QQQ	ETF	143.58	143.7	143.54	143.7	34287.0
2017-06-09 08:00:00	QQQ	ETF	143.69	143.7	143.57	143.64	41288.0
2017-06-09 08:30:00	QQQ	ETF	143.66	143.7	143.64	143.65	15893.0
2017-06-09 09:00:00	QQQ	ETF	143.64	143.72	143.62	143.72	76516.0
2017-06-09 09:30:00	QQQ	ETF	143.73	143.795	143.42	143.63	2949747.0
2017-06-09 10:00:00	QQQ	ETF	143.63	143.9	143.57	143.84	2587245.0
2017-06-09 10:30:00	QQQ	ETF	143.85	143.87	143.6	143.6401	2319427.0
2017-06-09 11:00:00	QQQ	ETF	143.64	143.69	143.115	143.23	2782230.0
2017-06-09 11:30:00	QQQ	ETF	143.23	143.33	143.02	143.02	2464697.0
2017-06-09 12:00:00	QQQ	ETF	143.03	143.03	142.12	142.28	5988790.0
2017-06-09 12:30:00	QQQ	ETF	142.28	142.335	141.78	142.05	6588203.0
2017-06-09 13:00:00	QQQ	ETF	142.05	142.1185	141.11	141.51	6951859.0

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

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