PREVIEW / etf_30min / 2018-05-21

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-05-21.parquet
  size:    459 KB
  rows:    15,966

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-05-21 04:00:00	SPY	ETF	272.83	272.83	272.67	272.8	7431.0
2018-05-21 04:30:00	SPY	ETF	272.8	272.95	272.79	272.94	30146.0
2018-05-21 05:00:00	SPY	ETF	272.98	273.05	272.97	272.98	5142.0
2018-05-21 05:30:00	SPY	ETF	272.97	273.05	272.92	272.94	6665.0
2018-05-21 06:00:00	SPY	ETF	273.01	273.01	272.94	272.99	11810.0
2018-05-21 06:30:00	SPY	ETF	272.9	273.11	272.9	273.0	45880.0
2018-05-21 07:00:00	SPY	ETF	272.98	273.0	272.94	272.94	107696.0
2018-05-21 07:30:00	SPY	ETF	272.94	273.0	272.89	272.92	59190.0
2018-05-21 08:00:00	SPY	ETF	272.92	272.9899	272.7	272.93	223640.0
2018-05-21 08:30:00	SPY	ETF	272.92	273.06	271.33	272.97	477708.0
2018-05-21 09:00:00	SPY	ETF	272.95	273.0	272.85	272.99	342126.0
2018-05-21 09:30:00	SPY	ETF	273.01	273.78	272.97	273.275	7937562.0
2018-05-21 10:00:00	SPY	ETF	273.275	273.61	273.19	273.56	3334664.0
2018-05-21 10:30:00	SPY	ETF	273.56	273.98	273.56	273.78	2984047.0
2018-05-21 11:00:00	SPY	ETF	273.7892	273.87	272.77	272.945	3337148.0
2018-05-21 11:30:00	SPY	ETF	272.95	273.125	272.6	273.12	3559365.0
2018-05-21 12:00:00	SPY	ETF	273.13	273.61	273.02	273.35	5385425.0
2018-05-21 12:30:00	SPY	ETF	273.35	273.49	273.23	273.36	1620362.0
2018-05-21 13:00:00	SPY	ETF	273.36	273.69	273.36	273.445	1731131.0
2018-05-21 13:30:00	SPY	ETF	273.45	273.64	273.35	273.59	1293945.0
2018-05-21 14:00:00	SPY	ETF	273.6	273.62	273.16	273.223	2483510.0
2018-05-21 14:30:00	SPY	ETF	273.23	273.35	272.8608	273.28	3607516.0
2018-05-21 15:00:00	SPY	ETF	273.27	273.42	272.9	273.06	2362639.0
2018-05-21 15:30:00	SPY	ETF	273.06	273.41	272.9	273.36	7306801.0
2018-05-21 16:00:00	SPY	ETF	273.36	273.41	273.23	273.33	7550133.0
2018-05-21 16:30:00	SPY	ETF	273.33	273.37	273.2	273.32	294858.0
2018-05-21 17:00:00	SPY	ETF	273.33	273.37	273.23	273.36	39479.0
2018-05-21 17:30:00	SPY	ETF	273.36	273.36	273.24	273.24	52382.0
2018-05-21 18:00:00	SPY	ETF	273.27	273.32	273.14	273.24	43397.0
2018-05-21 18:30:00	SPY	ETF	273.24	273.3	273.0507	273.3	185407.0
2018-05-21 19:00:00	SPY	ETF	273.3	273.32	273.21	273.22	2320.0
2018-05-21 19:30:00	SPY	ETF	273.2	273.25	273.19	273.25	9370.0
2018-05-21 04:00:00	QQQ	ETF	168.41	168.49	168.4	168.47	4300.0
2018-05-21 04:30:00	QQQ	ETF	168.46	168.59	168.46	168.59	2600.0
2018-05-21 05:00:00	QQQ	ETF	168.64	168.76	168.64	168.71	1900.0
2018-05-21 05:30:00	QQQ	ETF	168.67	168.72	168.57	168.59	5190.0
2018-05-21 06:00:00	QQQ	ETF	168.59	168.62	168.54	168.55	900.0
2018-05-21 06:30:00	QQQ	ETF	168.51	168.71	168.51	168.62	3838.0
2018-05-21 07:00:00	QQQ	ETF	168.58	168.69	168.54	168.63	121023.0
2018-05-21 07:30:00	QQQ	ETF	168.65	168.67	168.57	168.61	72993.0
2018-05-21 08:00:00	QQQ	ETF	168.6	168.68	168.51	168.65	91351.0
2018-05-21 08:30:00	QQQ	ETF	168.64	168.88	168.62	168.79	252636.0
2018-05-21 09:00:00	QQQ	ETF	168.8	168.8	168.67	168.73	249401.0
2018-05-21 09:30:00	QQQ	ETF	168.72	169.5	168.7	169.2595	3253104.0
2018-05-21 10:00:00	QQQ	ETF	169.26	169.37	168.91	169.01	1105811.0
2018-05-21 10:30:00	QQQ	ETF	169.01	169.26	169.01	169.0853	1127952.0
2018-05-21 11:00:00	QQQ	ETF	169.1	169.18	167.89	168.02	1898214.0
2018-05-21 11:30:00	QQQ	ETF	168.04	168.26	167.68	168.26	1508825.0
2018-05-21 12:00:00	QQQ	ETF	168.26	168.61	168.14	168.43	1164911.0
2018-05-21 12:30:00	QQQ	ETF	168.415	168.539	168.36	168.4658	593732.0

> showing 50 of 15,966 rows — these rows as CSV

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