PREVIEW / etf_30min / 2018-09-18

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-09-18.parquet
  size:    476 KB
  rows:    16,344

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-09-18 04:00:00	SPY	ETF	289.6	289.94	289.51	289.94	26493.0
2018-09-18 04:30:00	SPY	ETF	289.83	289.91	289.78	289.86	8200.0
2018-09-18 05:00:00	SPY	ETF	289.84	290.13	289.84	290.03	9114.0
2018-09-18 05:30:00	SPY	ETF	289.96	290.07	289.85	290.0	41541.0
2018-09-18 06:00:00	SPY	ETF	290.03	290.07	289.9	289.92	19910.0
2018-09-18 06:30:00	SPY	ETF	289.99	290.04	289.92	290.04	17066.0
2018-09-18 07:00:00	SPY	ETF	289.99	290.1	289.77	289.77	90514.0
2018-09-18 07:30:00	SPY	ETF	289.79	289.99	289.77	289.96	142712.0
2018-09-18 08:00:00	SPY	ETF	289.95	290.02	289.11	289.83	110292.0
2018-09-18 08:30:00	SPY	ETF	289.85	290.21	289.84	290.08	179536.0
2018-09-18 09:00:00	SPY	ETF	290.07	290.1	289.4	289.58	719793.0
2018-09-18 09:30:00	SPY	ETF	289.58	290.57	289.55	290.2799	5832819.0
2018-09-18 10:00:00	SPY	ETF	290.28	290.7	289.97	290.57	4962704.0
2018-09-18 10:30:00	SPY	ETF	290.58	290.84	290.33	290.8	3422830.0
2018-09-18 11:00:00	SPY	ETF	290.8	291.11	290.65	291.1	3122689.0
2018-09-18 11:30:00	SPY	ETF	291.1	291.24	290.98	291.19	2179828.0
2018-09-18 12:00:00	SPY	ETF	291.19	291.46	291.05	291.05	3002890.0
2018-09-18 12:30:00	SPY	ETF	291.05	291.23	290.95	291.015	2417425.0
2018-09-18 13:00:00	SPY	ETF	291.02	291.24	290.98	290.98	2032249.0
2018-09-18 13:30:00	SPY	ETF	290.98	291.255	290.88	291.225	2157168.0
2018-09-18 14:00:00	SPY	ETF	291.225	291.5	291.17	291.43	4450490.0
2018-09-18 14:30:00	SPY	ETF	291.44	291.58	291.24	291.28	3421232.0
2018-09-18 15:00:00	SPY	ETF	291.28	291.44	291.18	291.305	2571129.0
2018-09-18 15:30:00	SPY	ETF	291.305	291.31	290.85	290.9	8897843.0
2018-09-18 16:00:00	SPY	ETF	290.9	291.245	289.3158	291.01	9625875.0
2018-09-18 16:30:00	SPY	ETF	291.01	291.1	290.94	291.06	310832.0
2018-09-18 17:00:00	SPY	ETF	291.06	291.09	291.03	291.08	8150.0
2018-09-18 17:30:00	SPY	ETF	291.05	291.08	291.04	291.05	8911.0
2018-09-18 18:00:00	SPY	ETF	291.09	291.17	291.08	291.13	40872.0
2018-09-18 18:30:00	SPY	ETF	291.14	291.31	291.14	291.25	22822.0
2018-09-18 19:00:00	SPY	ETF	291.21	291.27	291.2	291.2	3620.0
2018-09-18 19:30:00	SPY	ETF	291.23	291.25	291.01	291.01	17407.0
2018-09-18 04:00:00	QQQ	ETF	181.51	181.81	181.51	181.81	27216.0
2018-09-18 04:30:00	QQQ	ETF	181.7	181.77	181.64	181.69	28770.0
2018-09-18 05:00:00	QQQ	ETF	181.7	181.9	181.7	181.83	15129.0
2018-09-18 05:30:00	QQQ	ETF	181.87	181.93	181.73	181.93	20466.0
2018-09-18 06:00:00	QQQ	ETF	181.94	181.96	181.8	181.8	17315.0
2018-09-18 06:30:00	QQQ	ETF	181.86	181.93	181.76	181.88	15668.0
2018-09-18 07:00:00	QQQ	ETF	181.84	181.89	181.39	181.43	72492.0
2018-09-18 07:30:00	QQQ	ETF	181.43	181.69	181.42	181.68	57932.0
2018-09-18 08:00:00	QQQ	ETF	181.83	181.88	181.03	181.64	129308.0
2018-09-18 08:30:00	QQQ	ETF	181.67	181.95	181.67	181.83	218348.0
2018-09-18 09:00:00	QQQ	ETF	181.8	181.82	181.38	181.49	314567.0
2018-09-18 09:30:00	QQQ	ETF	181.51	182.9	181.4	182.73	4689064.0
2018-09-18 10:00:00	QQQ	ETF	182.74	183.25	182.64	183.01	2988221.0
2018-09-18 10:30:00	QQQ	ETF	183.01	183.31	182.75	183.27	1654794.0
2018-09-18 11:00:00	QQQ	ETF	183.27	183.52	183.09	183.505	1592551.0
2018-09-18 11:30:00	QQQ	ETF	183.505	183.68	183.39	183.52	1607803.0
2018-09-18 12:00:00	QQQ	ETF	183.53	183.73	183.3	183.3	1268607.0
2018-09-18 12:30:00	QQQ	ETF	183.29	183.4099	182.97	183.11	1289004.0

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

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