PREVIEW / etf_30min / 2017-06-28

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-06-28.parquet
  size:    432 KB
  rows:    14,876

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-28 04:00:00	SPY	ETF	241.32	241.37	241.15	241.21	20700.0
2017-06-28 04:30:00	SPY	ETF	241.35	241.48	241.35	241.45	3600.0
2017-06-28 05:00:00	SPY	ETF	241.48	241.59	241.48	241.58	25400.0
2017-06-28 05:30:00	SPY	ETF	241.58	241.84	241.58	241.82	9438.0
2017-06-28 06:00:00	SPY	ETF	241.87	242.04	241.87	241.95	15369.0
2017-06-28 06:30:00	SPY	ETF	241.92	242.02	241.89	241.9	52219.0
2017-06-28 07:00:00	SPY	ETF	241.9	242.02	241.83	242.02	141358.0
2017-06-28 07:30:00	SPY	ETF	241.95	242.1	241.95	242.05	309753.0
2017-06-28 08:00:00	SPY	ETF	242.05	242.57	241.95	242.4	913796.0
2017-06-28 08:30:00	SPY	ETF	242.39	242.41	242.22	242.35	353152.0
2017-06-28 09:00:00	SPY	ETF	242.35	242.54	242.33	242.51	288620.0
2017-06-28 09:30:00	SPY	ETF	242.5	242.7	242.23	242.335	6744705.0
2017-06-28 10:00:00	SPY	ETF	242.33	242.88	242.305	242.59	6068664.0
2017-06-28 10:30:00	SPY	ETF	242.59	243.29	242.59	243.125	6335101.0
2017-06-28 11:00:00	SPY	ETF	243.125	243.24	243.05	243.13	3793397.0
2017-06-28 11:30:00	SPY	ETF	243.14	243.48	243.09	243.3	3158778.0
2017-06-28 12:00:00	SPY	ETF	243.3	243.42	243.23	243.2858	2713120.0
2017-06-28 12:30:00	SPY	ETF	243.29	243.56	243.24	243.5	2797223.0
2017-06-28 13:00:00	SPY	ETF	243.51	243.65	243.44	243.65	2077954.0
2017-06-28 13:30:00	SPY	ETF	243.65	243.71	243.555	243.59	2436708.0
2017-06-28 14:00:00	SPY	ETF	243.59	243.65	243.35	243.38	3172062.0
2017-06-28 14:30:00	SPY	ETF	243.39	243.53	243.35	243.49	2884429.0
2017-06-28 15:00:00	SPY	ETF	243.49	243.67	243.45	243.64	3651730.0
2017-06-28 15:30:00	SPY	ETF	243.645	243.715	243.33	243.46	11459078.0
2017-06-28 16:00:00	SPY	ETF	243.47	243.63	243.39	243.52	7680504.0
2017-06-28 16:30:00	SPY	ETF	243.52	243.88	243.2366	243.86	877585.0
2017-06-28 17:00:00	SPY	ETF	243.79	243.88	243.79	243.86	121032.0
2017-06-28 17:30:00	SPY	ETF	243.87	243.89	243.81	243.82	30707.0
2017-06-28 18:00:00	SPY	ETF	243.82	244.04	243.79	243.94	81355.0
2017-06-28 18:30:00	SPY	ETF	243.95	243.99	243.92	243.93	12105.0
2017-06-28 19:00:00	SPY	ETF	243.97	243.97	243.88	243.92	5214.0
2017-06-28 19:30:00	SPY	ETF	243.9	243.98	243.88	243.98	34999.0
2017-06-28 04:00:00	QQQ	ETF	137.65	137.65	137.07	137.16	19501.0
2017-06-28 04:30:00	QQQ	ETF	137.17	137.39	137.15	137.3	24775.0
2017-06-28 05:00:00	QQQ	ETF	137.34	137.46	137.3	137.37	20152.0
2017-06-28 05:30:00	QQQ	ETF	137.54	138.0	137.54	137.85	27407.0
2017-06-28 06:00:00	QQQ	ETF	137.83	137.85	137.71	137.71	2200.0
2017-06-28 06:30:00	QQQ	ETF	137.71	137.77	137.56	137.56	17305.0
2017-06-28 07:00:00	QQQ	ETF	137.6	137.76	137.53	137.76	61640.0
2017-06-28 07:30:00	QQQ	ETF	137.7	137.99	137.68	137.99	90834.0
2017-06-28 08:00:00	QQQ	ETF	137.7	138.62	137.7	138.43	641408.0
2017-06-28 08:30:00	QQQ	ETF	138.43	138.51	138.31	138.42	234306.0
2017-06-28 09:00:00	QQQ	ETF	138.42	138.56	138.39	138.54	249490.0
2017-06-28 09:30:00	QQQ	ETF	138.54	138.64	137.74	137.86	8085517.0
2017-06-28 10:00:00	QQQ	ETF	137.85	138.55	137.81	138.3605	5104993.0
2017-06-28 10:30:00	QQQ	ETF	138.37	139.33	138.36	139.18	6584714.0
2017-06-28 11:00:00	QQQ	ETF	139.17	139.3	138.978	139.01	2946841.0
2017-06-28 11:30:00	QQQ	ETF	139.02	139.3	138.9	139.09	1430909.0
2017-06-28 12:00:00	QQQ	ETF	139.09	139.28	139.06	139.23	1313179.0
2017-06-28 12:30:00	QQQ	ETF	139.23	139.71	139.17	139.63	3600558.0

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

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