PREVIEW / etf_30min / 2017-08-24

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-08-24.parquet
  size:    421 KB
  rows:    14,494

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-08-24 04:00:00	SPY	ETF	244.25	244.47	244.25	244.47	26570.0
2017-08-24 04:30:00	SPY	ETF	244.48	244.7	244.45	244.63	15681.0
2017-08-24 05:00:00	SPY	ETF	244.58	244.63	244.57	244.63	3326.0
2017-08-24 05:30:00	SPY	ETF	244.6	244.7	244.57	244.7	8005.0
2017-08-24 06:00:00	SPY	ETF	244.71	244.79	244.68	244.7	24068.0
2017-08-24 06:30:00	SPY	ETF	244.73	244.73	244.62	244.67	6618.0
2017-08-24 07:00:00	SPY	ETF	244.65	244.91	244.57	244.9	448809.0
2017-08-24 07:30:00	SPY	ETF	244.9	244.94	244.85	244.87	55743.0
2017-08-24 08:00:00	SPY	ETF	244.85	245.02	244.6	244.94	148946.0
2017-08-24 08:30:00	SPY	ETF	244.93	245.09	244.91	245.05	328769.0
2017-08-24 09:00:00	SPY	ETF	245.05	245.07	244.97	245.0	270270.0
2017-08-24 09:30:00	SPY	ETF	245.0	245.18	244.12	244.19	6500071.0
2017-08-24 10:00:00	SPY	ETF	244.19	244.6	244.0	244.53	4411435.0
2017-08-24 10:30:00	SPY	ETF	244.54	245.0	244.54	244.69	2307561.0
2017-08-24 11:00:00	SPY	ETF	244.69	244.76	243.91	244.09	3653270.0
2017-08-24 11:30:00	SPY	ETF	244.08	244.24	243.75	244.22	5048558.0
2017-08-24 12:00:00	SPY	ETF	244.23	244.34	244.14	244.21	2376628.0
2017-08-24 12:30:00	SPY	ETF	244.22	244.37	244.08	244.25	1264591.0
2017-08-24 13:00:00	SPY	ETF	244.25	244.69	244.18	244.57	2007410.0
2017-08-24 13:30:00	SPY	ETF	244.57	244.57	244.35	244.37	1365901.0
2017-08-24 14:00:00	SPY	ETF	244.36	244.44	244.02	244.19	2356503.0
2017-08-24 14:30:00	SPY	ETF	244.19	244.36	244.07	244.33	1785729.0
2017-08-24 15:00:00	SPY	ETF	244.32	244.42	244.06	244.32	3079411.0
2017-08-24 15:30:00	SPY	ETF	244.315	244.36	243.92	244.03	7830044.0
2017-08-24 16:00:00	SPY	ETF	244.04	244.38	243.99	244.37	3765946.0
2017-08-24 16:30:00	SPY	ETF	244.38	244.53	243.99	244.5	219066.0
2017-08-24 17:00:00	SPY	ETF	244.48	244.52	244.46	244.5	453450.0
2017-08-24 17:30:00	SPY	ETF	244.48	244.5	244.47	244.5	17172.0
2017-08-24 18:00:00	SPY	ETF	244.5	244.64	244.46	244.51	102500.0
2017-08-24 18:30:00	SPY	ETF	244.52	244.6	244.51	244.53	23437.0
2017-08-24 19:00:00	SPY	ETF	244.53	244.53	244.43	244.43	32308.0
2017-08-24 19:30:00	SPY	ETF	244.46	244.51	244.42	244.47	30596.0
2017-08-24 04:00:00	QQQ	ETF	142.41	142.56	142.41	142.56	6469.0
2017-08-24 04:30:00	QQQ	ETF	142.7	142.8	142.7	142.8	1000.0
2017-08-24 05:00:00	QQQ	ETF	142.74	142.75	142.74	142.75	312.0
2017-08-24 05:30:00	QQQ	ETF	142.8	142.84	142.8	142.84	4999.0
2017-08-24 06:00:00	QQQ	ETF	142.87	142.88	142.84	142.84	4397.0
2017-08-24 06:30:00	QQQ	ETF	142.87	142.9	142.79	142.85	10976.0
2017-08-24 07:00:00	QQQ	ETF	142.87	142.96	142.8	142.96	20365.0
2017-08-24 07:30:00	QQQ	ETF	142.94	142.97	142.9	142.95	15837.0
2017-08-24 08:00:00	QQQ	ETF	142.93	143.07	142.87	143.02	40316.0
2017-08-24 08:30:00	QQQ	ETF	143.01	143.08	143.0	143.06	52520.0
2017-08-24 09:00:00	QQQ	ETF	143.08	143.11	143.0	143.03	54659.0
2017-08-24 09:30:00	QQQ	ETF	143.03	143.17	142.2	142.26	2870116.0
2017-08-24 10:00:00	QQQ	ETF	142.26	142.47	141.93	142.36	2810857.0
2017-08-24 10:30:00	QQQ	ETF	142.37	142.65	142.36	142.44	1181098.0
2017-08-24 11:00:00	QQQ	ETF	142.45	142.5	141.65	141.78	2275054.0
2017-08-24 11:30:00	QQQ	ETF	141.78	141.89	141.47	141.86	3375904.0
2017-08-24 12:00:00	QQQ	ETF	141.86	141.96	141.73	141.87	1203003.0
2017-08-24 12:30:00	QQQ	ETF	141.88	142.1456	141.8	142.06	1393305.0

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

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