PREVIEW / etf_30min / 2019-09-18

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-09-18.parquet
  size:    502 KB
  rows:    17,461

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
2019-09-18 04:00:00	SPY	ETF	300.74	300.8	300.73	300.73	2330.0
2019-09-18 04:30:00	SPY	ETF	300.73	300.73	300.64	300.64	3360.0
2019-09-18 05:00:00	SPY	ETF	300.55	300.56	300.5	300.56	8690.0
2019-09-18 05:30:00	SPY	ETF	300.56	300.56	300.48	300.52	3275.0
2019-09-18 06:00:00	SPY	ETF	300.52	300.53	300.43	300.51	3750.0
2019-09-18 06:30:00	SPY	ETF	300.51	300.6	300.51	300.53	22896.0
2019-09-18 07:00:00	SPY	ETF	300.63	300.63	300.33	300.46	146888.0
2019-09-18 07:30:00	SPY	ETF	300.5	300.55	300.18	300.36	194965.0
2019-09-18 08:00:00	SPY	ETF	300.36	300.57	300.36	300.44	106638.0
2019-09-18 08:30:00	SPY	ETF	300.44	300.66	300.44	300.63	117082.0
2019-09-18 09:00:00	SPY	ETF	300.62	300.66	300.47	300.52	88654.0
2019-09-18 09:30:00	SPY	ETF	300.49	300.58	299.89	300.16	4893700.0
2019-09-18 10:00:00	SPY	ETF	300.15	300.51	300.11	300.51	2578424.0
2019-09-18 10:30:00	SPY	ETF	300.5	300.57	300.18	300.28	2243163.0
2019-09-18 11:00:00	SPY	ETF	300.27	300.3	300.1	300.14	1644049.0
2019-09-18 11:30:00	SPY	ETF	300.145	300.2	300.02	300.19	1600502.0
2019-09-18 12:00:00	SPY	ETF	300.18	300.24	300.06	300.15	1580528.0
2019-09-18 12:30:00	SPY	ETF	300.155	300.245	300.01	300.0116	1324199.0
2019-09-18 13:00:00	SPY	ETF	300.01	300.02	299.66	299.69	2244832.0
2019-09-18 13:30:00	SPY	ETF	299.68	300.21	299.62	300.15	3429602.0
2019-09-18 14:00:00	SPY	ETF	300.1699	300.59	298.53	298.78	11755633.0
2019-09-18 14:30:00	SPY	ETF	298.78	299.31	298.24	299.07	13621222.0
2019-09-18 15:00:00	SPY	ETF	299.06	300.07	298.82	300.01	10568581.0
2019-09-18 15:30:00	SPY	ETF	300.005	301.22	300.005	301.1	9956971.0
2019-09-18 16:00:00	SPY	ETF	301.1	301.39	300.98	301.05	3920651.0
2019-09-18 16:30:00	SPY	ETF	301.06	301.46	301.06	301.11	422627.0
2019-09-18 17:00:00	SPY	ETF	301.14	301.21	300.96	301.15	139532.0
2019-09-18 17:30:00	SPY	ETF	301.2	301.25	301.11	301.19	82169.0
2019-09-18 18:00:00	SPY	ETF	301.13	301.21	301.03	301.07	102366.0
2019-09-18 18:30:00	SPY	ETF	301.09	301.15	301.02	301.05	38592.0
2019-09-18 19:00:00	SPY	ETF	301.01	301.06	300.98	301.0	95231.0
2019-09-18 19:30:00	SPY	ETF	300.96	300.96	300.8	300.82	76531.0
2019-09-18 04:00:00	QQQ	ETF	192.32	192.4	192.32	192.36	1080.0
2019-09-18 04:30:00	QQQ	ETF	192.36	192.39	192.25	192.25	4090.0
2019-09-18 05:00:00	QQQ	ETF	192.26	192.26	192.24	192.25	890.0
2019-09-18 05:30:00	QQQ	ETF	192.27	192.3	192.21	192.25	11797.0
2019-09-18 06:00:00	QQQ	ETF	192.28	192.28	192.17	192.22	6782.0
2019-09-18 06:30:00	QQQ	ETF	192.21	192.28	192.21	192.22	2500.0
2019-09-18 07:00:00	QQQ	ETF	192.33	192.33	192.15	192.25	16783.0
2019-09-18 07:30:00	QQQ	ETF	192.3	192.34	191.88	192.04	80773.0
2019-09-18 08:00:00	QQQ	ETF	192.3001	192.33	191.9	192.14	16420.0
2019-09-18 08:30:00	QQQ	ETF	192.16	192.36	192.16	192.29	42269.0
2019-09-18 09:00:00	QQQ	ETF	192.32	192.33	192.18	192.21	38682.0
2019-09-18 09:30:00	QQQ	ETF	192.2	192.25	191.76	191.97	2126089.0
2019-09-18 10:00:00	QQQ	ETF	191.97	192.15	191.93	192.07	937450.0
2019-09-18 10:30:00	QQQ	ETF	192.0789	192.14	191.9199	192.07	602068.0
2019-09-18 11:00:00	QQQ	ETF	192.06	192.1053	191.92	192.0	436892.0
2019-09-18 11:30:00	QQQ	ETF	191.99	192.06	191.92	191.97	605355.0
2019-09-18 12:00:00	QQQ	ETF	191.97	192.03	191.91	191.98	297000.0
2019-09-18 12:30:00	QQQ	ETF	191.98	192.03	191.6749	191.68	1037135.0

> showing 50 of 17,461 rows — these rows as CSV

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