PREVIEW / etf_30min / 2019-09-19

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-09-19.parquet
  size:    505 KB
  rows:    17,414

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-19 04:00:00	SPY	ETF	300.53	300.57	300.35	300.52	53512.0
2019-09-19 04:30:00	SPY	ETF	300.53	300.7	300.46	300.7	15761.0
2019-09-19 05:00:00	SPY	ETF	300.7	300.74	300.42	300.42	6200.0
2019-09-19 05:30:00	SPY	ETF	300.52	300.56	300.28	300.31	5576.0
2019-09-19 06:00:00	SPY	ETF	300.33	300.52	300.33	300.47	22701.0
2019-09-19 06:30:00	SPY	ETF	300.42	300.42	300.26	300.26	15470.0
2019-09-19 07:00:00	SPY	ETF	300.28	300.7	300.24	300.7	84671.0
2019-09-19 07:30:00	SPY	ETF	300.7	300.81	300.64	300.7	107537.0
2019-09-19 08:00:00	SPY	ETF	300.41	301.08	299.55	301.0	283716.0
2019-09-19 08:30:00	SPY	ETF	301.05	301.71	300.94	301.64	500260.0
2019-09-19 09:00:00	SPY	ETF	301.59	301.76	301.47	301.54	428553.0
2019-09-19 09:30:00	SPY	ETF	301.53	302.2	301.48	301.87	6873730.0
2019-09-19 10:00:00	SPY	ETF	301.875	302.38	301.86	302.22	7861333.0
2019-09-19 10:30:00	SPY	ETF	302.22	302.52	302.13	302.18	6659291.0
2019-09-19 11:00:00	SPY	ETF	302.18	302.41	302.04	302.35	4311852.0
2019-09-19 11:30:00	SPY	ETF	302.35	302.63	302.12	302.285	3454748.0
2019-09-19 12:00:00	SPY	ETF	302.29	302.41	301.61	301.66	4041333.0
2019-09-19 12:30:00	SPY	ETF	301.65	302.07	301.55	301.903	4181002.0
2019-09-19 13:00:00	SPY	ETF	301.905	302.12	301.65	301.8	3567937.0
2019-09-19 13:30:00	SPY	ETF	301.79	301.86	301.17	301.78	5502543.0
2019-09-19 14:00:00	SPY	ETF	301.77	301.88	301.61	301.7	3841310.0
2019-09-19 14:30:00	SPY	ETF	301.695	301.7	301.36	301.54	2760789.0
2019-09-19 15:00:00	SPY	ETF	301.545	301.66	301.3099	301.49	3398878.0
2019-09-19 15:30:00	SPY	ETF	301.49	301.49	300.7103	301.06	9923294.0
2019-09-19 16:00:00	SPY	ETF	301.05	301.25	300.98	301.16	6605172.0
2019-09-19 16:30:00	SPY	ETF	301.17	301.17	300.89	301.05	1196249.0
2019-09-19 17:00:00	SPY	ETF	301.04	301.06	300.76	300.94	276343.0
2019-09-19 17:30:00	SPY	ETF	300.94	300.96	300.85	300.92	23083.0
2019-09-19 18:00:00	SPY	ETF	300.92	301.29	300.75	301.25	76465.0
2019-09-19 18:30:00	SPY	ETF	301.22	301.3	301.22	301.25	17215.0
2019-09-19 19:00:00	SPY	ETF	301.27	301.35	301.25	301.25	8466.0
2019-09-19 19:30:00	SPY	ETF	301.27	301.36	301.23	301.23	17247.0
2019-09-19 04:00:00	QQQ	ETF	192.16	192.2	192.04	192.2	14614.0
2019-09-19 04:30:00	QQQ	ETF	192.21	192.36	192.15	192.28	3140.0
2019-09-19 05:00:00	QQQ	ETF	192.25	192.3	192.05	192.13	6330.0
2019-09-19 05:30:00	QQQ	ETF	192.17	192.17	191.9	191.94	7440.0
2019-09-19 06:00:00	QQQ	ETF	192.08	192.11	192.01	192.05	2000.0
2019-09-19 06:30:00	QQQ	ETF	192.04	192.04	191.85	191.86	33113.0
2019-09-19 07:00:00	QQQ	ETF	191.87	192.23	191.83	192.17	29705.0
2019-09-19 07:30:00	QQQ	ETF	192.27	192.4	192.25	192.29	16580.0
2019-09-19 08:00:00	QQQ	ETF	192.2501	192.56	191.24	192.52	63519.0
2019-09-19 08:30:00	QQQ	ETF	192.52	193.14	192.46	193.04	198343.0
2019-09-19 09:00:00	QQQ	ETF	193.05	193.18	192.85	192.85	163151.0
2019-09-19 09:30:00	QQQ	ETF	192.86	193.8	192.86	193.57	3472156.0
2019-09-19 10:00:00	QQQ	ETF	193.6	193.94	193.58	193.78	1720996.0
2019-09-19 10:30:00	QQQ	ETF	193.8	194.035	193.75	193.75	1562559.0
2019-09-19 11:00:00	QQQ	ETF	193.75	193.8	193.58	193.69	910387.0
2019-09-19 11:30:00	QQQ	ETF	193.7	193.9	193.4	193.4841	1387552.0
2019-09-19 12:00:00	QQQ	ETF	193.49	193.63	192.81	192.89	1440301.0
2019-09-19 12:30:00	QQQ	ETF	192.88	193.2	192.78	193.06	1101401.0

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

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