PREVIEW / etf_30min / 2019-01-24

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-01-24.parquet
  size:    486 KB
  rows:    16,852

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-01-24 04:00:00	SPY	ETF	263.41	263.74	263.4	263.68	3983.0
2019-01-24 04:30:00	SPY	ETF	263.75	263.85	263.66	263.85	6313.0
2019-01-24 05:00:00	SPY	ETF	263.82	263.93	263.61	263.7	7786.0
2019-01-24 05:30:00	SPY	ETF	263.8	263.85	263.53	263.64	6558.0
2019-01-24 06:00:00	SPY	ETF	263.68	264.1	263.6	263.6	26568.0
2019-01-24 06:30:00	SPY	ETF	263.61	263.65	263.55	263.62	16075.0
2019-01-24 07:00:00	SPY	ETF	263.6	263.99	263.6	263.93	39522.0
2019-01-24 07:30:00	SPY	ETF	263.89	263.89	263.59	263.6	164139.0
2019-01-24 08:00:00	SPY	ETF	263.78	263.92	263.04	263.79	98749.0
2019-01-24 08:30:00	SPY	ETF	263.81	263.94	262.74	263.05	1260803.0
2019-01-24 09:00:00	SPY	ETF	263.0	263.56	262.93	263.22	293225.0
2019-01-24 09:30:00	SPY	ETF	263.21	263.56	262.47	262.94	6239120.0
2019-01-24 10:00:00	SPY	ETF	262.93	264.2	262.69	264.09	5573061.0
2019-01-24 10:30:00	SPY	ETF	264.08	264.18	263.14	263.42	4288440.0
2019-01-24 11:00:00	SPY	ETF	263.41	263.61	262.72	263.13	3030476.0
2019-01-24 11:30:00	SPY	ETF	263.13	264.0	262.87	263.8233	3901619.0
2019-01-24 12:00:00	SPY	ETF	263.8089	263.84	263.24	263.27	2022888.0
2019-01-24 12:30:00	SPY	ETF	263.26	263.44	262.65	262.83	2362933.0
2019-01-24 13:00:00	SPY	ETF	262.82	262.925	262.08	262.37	3872782.0
2019-01-24 13:30:00	SPY	ETF	262.37	262.84	262.2	262.76	2772648.0
2019-01-24 14:00:00	SPY	ETF	262.76	263.04	262.46	262.91	2891362.0
2019-01-24 14:30:00	SPY	ETF	262.9	263.28	262.71	263.15	3565789.0
2019-01-24 15:00:00	SPY	ETF	263.14	263.71	263.04	263.45	3306008.0
2019-01-24 15:30:00	SPY	ETF	263.46	263.76	263.2	263.62	6515767.0
2019-01-24 16:00:00	SPY	ETF	263.61	263.6564	262.83	262.92	3764165.0
2019-01-24 16:30:00	SPY	ETF	262.94	263.55	262.9	263.2	298875.0
2019-01-24 17:00:00	SPY	ETF	263.23	263.25	262.87	263.12	202478.0
2019-01-24 17:30:00	SPY	ETF	263.12	263.36	263.12	263.19	342601.0
2019-01-24 18:00:00	SPY	ETF	263.19	263.23	262.94	263.07	129375.0
2019-01-24 18:30:00	SPY	ETF	263.13	263.55	263.0	263.31	69082.0
2019-01-24 19:00:00	SPY	ETF	263.34	263.59	263.23	263.33	74701.0
2019-01-24 19:30:00	SPY	ETF	263.36	263.5	263.3	263.49	51971.0
2019-01-24 04:00:00	QQQ	ETF	162.53	162.85	162.47	162.74	11859.0
2019-01-24 04:30:00	QQQ	ETF	162.79	162.97	162.76	162.97	12703.0
2019-01-24 05:00:00	QQQ	ETF	162.94	162.99	162.85	162.94	6773.0
2019-01-24 05:30:00	QQQ	ETF	162.92	162.92	162.79	162.81	22635.0
2019-01-24 06:00:00	QQQ	ETF	162.84	163.13	162.83	162.83	18318.0
2019-01-24 06:30:00	QQQ	ETF	162.86	162.95	162.8	162.87	23080.0
2019-01-24 07:00:00	QQQ	ETF	162.88	163.06	162.85	162.99	119900.0
2019-01-24 07:30:00	QQQ	ETF	162.97	163.02	162.81	162.82	91770.0
2019-01-24 08:00:00	QQQ	ETF	162.85	163.04	162.44	162.95	70192.0
2019-01-24 08:30:00	QQQ	ETF	162.95	163.07	162.28	162.37	401053.0
2019-01-24 09:00:00	QQQ	ETF	162.39	162.89	162.39	162.67	173381.0
2019-01-24 09:30:00	QQQ	ETF	162.65	163.22	162.34	162.68	3801186.0
2019-01-24 10:00:00	QQQ	ETF	162.67	163.44	162.45	163.32	2773879.0
2019-01-24 10:30:00	QQQ	ETF	163.33	163.4	162.36	162.56	2187190.0
2019-01-24 11:00:00	QQQ	ETF	162.56	162.815	162.0626	162.48	1739678.0
2019-01-24 11:30:00	QQQ	ETF	162.48	163.23	162.37	163.17	2021256.0
2019-01-24 12:00:00	QQQ	ETF	163.16	163.18	162.76	162.88	619470.0
2019-01-24 12:30:00	QQQ	ETF	162.88	163.01	162.4	162.56	788535.0

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

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