PREVIEW / etf_30min / 2018-08-28

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-08-28.parquet
  size:    471 KB
  rows:    16,104

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
2018-08-28 04:00:00	SPY	ETF	289.87	289.89	289.83	289.89	22840.0
2018-08-28 04:30:00	SPY	ETF	289.87	289.94	289.77	289.77	11459.0
2018-08-28 05:00:00	SPY	ETF	289.83	290.06	289.83	290.06	1004.0
2018-08-28 05:30:00	SPY	ETF	290.09	290.15	290.06	290.13	3901.0
2018-08-28 06:00:00	SPY	ETF	290.13	290.16	290.06	290.16	5498.0
2018-08-28 06:30:00	SPY	ETF	290.11	290.14	290.08	290.08	910.0
2018-08-28 07:00:00	SPY	ETF	290.1	290.17	290.06	290.12	29224.0
2018-08-28 07:30:00	SPY	ETF	290.18	290.24	290.14	290.24	56391.0
2018-08-28 08:00:00	SPY	ETF	290.1099	290.3	289.8	290.25	40431.0
2018-08-28 08:30:00	SPY	ETF	290.27	290.3	290.19	290.26	84095.0
2018-08-28 09:00:00	SPY	ETF	290.28	290.56	290.28	290.3	303159.0
2018-08-28 09:30:00	SPY	ETF	290.3	290.4175	290.03	290.2	6055996.0
2018-08-28 10:00:00	SPY	ETF	290.2	290.2999	289.82	289.925	2577287.0
2018-08-28 10:30:00	SPY	ETF	289.9275	290.03	289.66	289.99	2233739.0
2018-08-28 11:00:00	SPY	ETF	289.99	290.12	289.83	290.0401	1565713.0
2018-08-28 11:30:00	SPY	ETF	290.04	290.0437	289.42	289.45	3705777.0
2018-08-28 12:00:00	SPY	ETF	289.45	289.8	289.4	289.66	2474381.0
2018-08-28 12:30:00	SPY	ETF	289.66	289.86	289.66	289.82	1302380.0
2018-08-28 13:00:00	SPY	ETF	289.82	289.98	289.61	289.695	1666889.0
2018-08-28 13:30:00	SPY	ETF	289.695	290.07	289.6	289.9236	2019427.0
2018-08-28 14:00:00	SPY	ETF	289.92	290.0	289.9	289.94	1267258.0
2018-08-28 14:30:00	SPY	ETF	289.94	289.99	289.79	289.96	4703262.0
2018-08-28 15:00:00	SPY	ETF	289.96	290.05	289.72	289.84	2294613.0
2018-08-28 15:30:00	SPY	ETF	289.83	289.925	289.5	289.88	8379978.0
2018-08-28 16:00:00	SPY	ETF	289.88	290.02	289.8012	289.99	4988235.0
2018-08-28 16:30:00	SPY	ETF	289.96	290.02	289.92	289.97	359054.0
2018-08-28 17:00:00	SPY	ETF	289.97	289.99	289.95	289.96	4444.0
2018-08-28 17:30:00	SPY	ETF	289.95	290.01	289.95	290.0	3483.0
2018-08-28 18:00:00	SPY	ETF	290.02	290.18	290.0	290.1	48108.0
2018-08-28 18:30:00	SPY	ETF	290.1	290.15	290.1	290.15	9240.0
2018-08-28 19:00:00	SPY	ETF	290.13	290.16	290.1	290.12	40806.0
2018-08-28 19:30:00	SPY	ETF	290.13	290.16	290.09	290.16	15645.0
2018-08-28 04:00:00	QQQ	ETF	184.49	184.58	184.49	184.58	1100.0
2018-08-28 04:30:00	QQQ	ETF	184.56	184.59	184.53	184.53	1900.0
2018-08-28 05:00:00	QQQ	ETF	184.49	184.7	184.49	184.69	4928.0
2018-08-28 05:30:00	QQQ	ETF	184.65	184.72	184.65	184.72	11802.0
2018-08-28 06:00:00	QQQ	ETF	184.71	184.71	184.65	184.67	5500.0
2018-08-28 06:30:00	QQQ	ETF	184.69	184.69	184.63	184.66	6317.0
2018-08-28 07:00:00	QQQ	ETF	184.65	184.71	184.65	184.7	34700.0
2018-08-28 07:30:00	QQQ	ETF	184.7	184.78	184.67	184.76	92668.0
2018-08-28 08:00:00	QQQ	ETF	184.78	184.91	184.45	184.85	121541.0
2018-08-28 08:30:00	QQQ	ETF	184.84	184.89	184.7599	184.78	76256.0
2018-08-28 09:00:00	QQQ	ETF	184.76	184.93	184.34	184.79	155862.0
2018-08-28 09:30:00	QQQ	ETF	184.8	185.02	184.5	184.7711	2799888.0
2018-08-28 10:00:00	QQQ	ETF	184.79	184.885	184.5001	184.62	1648326.0
2018-08-28 10:30:00	QQQ	ETF	184.61	184.73	184.35	184.58	1157653.0
2018-08-28 11:00:00	QQQ	ETF	184.58	184.7526	184.48	184.68	941531.0
2018-08-28 11:30:00	QQQ	ETF	184.68	184.68	184.23	184.3	1169304.0
2018-08-28 12:00:00	QQQ	ETF	184.29	184.6156	184.22	184.53	743818.0
2018-08-28 12:30:00	QQQ	ETF	184.53	184.715	184.53	184.655	473718.0

> showing 50 of 16,104 rows — these rows as CSV

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