PREVIEW / etf_30min / 2017-08-17

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-08-17.parquet
  size:    446 KB
  rows:    15,220

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-17 04:00:00	SPY	ETF	246.77	246.83	246.74	246.74	20244.0
2017-08-17 04:30:00	SPY	ETF	246.74	246.74	246.57	246.63	6712.0
2017-08-17 05:00:00	SPY	ETF	246.67	246.67	246.62	246.62	1100.0
2017-08-17 05:30:00	SPY	ETF	246.65	246.69	246.62	246.69	3500.0
2017-08-17 06:00:00	SPY	ETF	246.73	246.73	246.67	246.72	8300.0
2017-08-17 06:30:00	SPY	ETF	246.69	246.73	246.62	246.63	27358.0
2017-08-17 07:00:00	SPY	ETF	246.62	246.66	246.53	246.56	27978.0
2017-08-17 07:30:00	SPY	ETF	246.6	246.69	246.26	246.38	205205.0
2017-08-17 08:00:00	SPY	ETF	246.39	246.68	246.11	246.25	195703.0
2017-08-17 08:30:00	SPY	ETF	246.23	246.46	246.2	246.4	304852.0
2017-08-17 09:00:00	SPY	ETF	246.37	246.39	246.14	246.26	457520.0
2017-08-17 09:30:00	SPY	ETF	246.24	246.6	246.06	246.07	6112443.0
2017-08-17 10:00:00	SPY	ETF	246.07	246.1682	245.17	245.4422	14417748.0
2017-08-17 10:30:00	SPY	ETF	245.45	245.88	245.24	245.52	10305148.0
2017-08-17 11:00:00	SPY	ETF	245.52	246.0	245.5199	245.5801	5107842.0
2017-08-17 11:30:00	SPY	ETF	245.585	245.71	245.18	245.34	6628384.0
2017-08-17 12:00:00	SPY	ETF	245.34	245.49	244.9	245.0195	9175347.0
2017-08-17 12:30:00	SPY	ETF	245.02	245.04	244.44	244.6	6996948.0
2017-08-17 13:00:00	SPY	ETF	244.6	244.625	244.2925	244.54	5293338.0
2017-08-17 13:30:00	SPY	ETF	244.54	244.8	244.32	244.59	4610260.0
2017-08-17 14:00:00	SPY	ETF	244.59	244.645	244.08	244.44	4842181.0
2017-08-17 14:30:00	SPY	ETF	244.44	244.47	244.06	244.28	5056144.0
2017-08-17 15:00:00	SPY	ETF	244.27	244.28	243.59	243.66	9134587.0
2017-08-17 15:30:00	SPY	ETF	243.66	243.93	243.1	243.13	23826925.0
2017-08-17 16:00:00	SPY	ETF	243.13	243.3	243.0	243.2	10688148.0
2017-08-17 16:30:00	SPY	ETF	243.21	243.25	242.61	242.99	1465384.0
2017-08-17 17:00:00	SPY	ETF	242.92	245.528	242.9	242.95	326029.0
2017-08-17 17:30:00	SPY	ETF	242.96	242.96	242.8	242.83	267220.0
2017-08-17 18:00:00	SPY	ETF	242.85	243.05	242.81	243.0	279005.0
2017-08-17 18:30:00	SPY	ETF	242.95	243.05	242.95	243.01	18958.0
2017-08-17 19:00:00	SPY	ETF	243.04	243.1	243.04	243.09	28240.0
2017-08-17 19:30:00	SPY	ETF	243.09	243.1	242.83	242.91	38540.0
2017-08-17 04:00:00	QQQ	ETF	144.1	144.18	144.1	144.12	1496.0
2017-08-17 04:30:00	QQQ	ETF	143.97	144.02	143.96	144.02	635.0
2017-08-17 05:30:00	QQQ	ETF	143.94	143.94	143.91	143.91	742.0
2017-08-17 06:00:00	QQQ	ETF	143.93	143.93	143.93	143.93	1400.0
2017-08-17 06:30:00	QQQ	ETF	143.97	143.97	143.93	143.93	12670.0
2017-08-17 07:00:00	QQQ	ETF	143.91	143.97	143.91	143.94	4000.0
2017-08-17 07:30:00	QQQ	ETF	144.02	144.05	143.65	143.75	57854.0
2017-08-17 08:00:00	QQQ	ETF	143.75	143.94	143.55	143.59	120300.0
2017-08-17 08:30:00	QQQ	ETF	143.58	143.73	143.57	143.7	162755.0
2017-08-17 09:00:00	QQQ	ETF	143.68	143.76	143.57	143.76	133386.0
2017-08-17 09:30:00	QQQ	ETF	143.73	143.94	143.54	143.58	3633455.0
2017-08-17 10:00:00	QQQ	ETF	143.57	143.57	142.6	142.81	6628426.0
2017-08-17 10:30:00	QQQ	ETF	142.81	143.12	142.69	142.82	5459507.0
2017-08-17 11:00:00	QQQ	ETF	142.83	143.18	142.83	142.93	2572130.0
2017-08-17 11:30:00	QQQ	ETF	142.9508	143.03	142.71	142.85	2393720.0
2017-08-17 12:00:00	QQQ	ETF	142.85	142.96	142.3993	142.55	3065457.0
2017-08-17 12:30:00	QQQ	ETF	142.545	142.56	142.06	142.17	3188686.0
2017-08-17 13:00:00	QQQ	ETF	142.17	142.26	141.95	142.2	2224846.0

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

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