PREVIEW / etf_30min / 2018-03-21

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-03-21.parquet
  size:    456 KB
  rows:    15,767

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-03-21 04:00:00	SPY	ETF	271.35	271.36	271.14	271.14	5945.0
2018-03-21 04:30:00	SPY	ETF	271.07	271.07	270.9	270.97	3378.0
2018-03-21 05:00:00	SPY	ETF	271.02	271.02	270.77	270.98	13966.0
2018-03-21 05:30:00	SPY	ETF	271.0	271.05	270.88	271.05	3988.0
2018-03-21 06:00:00	SPY	ETF	271.07	271.14	270.94	271.13	4360.0
2018-03-21 06:30:00	SPY	ETF	271.17	271.36	271.17	271.25	26400.0
2018-03-21 07:00:00	SPY	ETF	271.24	271.37	271.13	271.25	42938.0
2018-03-21 07:30:00	SPY	ETF	271.25	271.26	270.73	270.98	81795.0
2018-03-21 08:00:00	SPY	ETF	271.15	271.7	270.68	270.98	154034.0
2018-03-21 08:30:00	SPY	ETF	270.98	271.1	270.8	271.06	109983.0
2018-03-21 09:00:00	SPY	ETF	271.04	271.04	270.68	270.87	336163.0
2018-03-21 09:30:00	SPY	ETF	270.9	271.01	270.45	270.61	4408238.0
2018-03-21 10:00:00	SPY	ETF	270.62	271.13	270.61	270.8	2983981.0
2018-03-21 10:30:00	SPY	ETF	270.8	271.23	270.53	270.9911	5057422.0
2018-03-21 11:00:00	SPY	ETF	270.995	271.28	270.87	271.25	2372053.0
2018-03-21 11:30:00	SPY	ETF	271.25	272.3	271.24	272.01	3726986.0
2018-03-21 12:00:00	SPY	ETF	272.01	272.19	271.87	272.09	3125138.0
2018-03-21 12:30:00	SPY	ETF	272.1	272.27	272.0	272.22	1268202.0
2018-03-21 13:00:00	SPY	ETF	272.23	272.25	271.665	271.77	2748561.0
2018-03-21 13:30:00	SPY	ETF	271.78	272.13	271.51	272.03	3572471.0
2018-03-21 14:00:00	SPY	ETF	272.0	273.27	271.36	272.0	14595912.0
2018-03-21 14:30:00	SPY	ETF	272.02	272.16	270.19	270.8807	9144310.0
2018-03-21 15:00:00	SPY	ETF	270.88	272.24	270.77	271.32	7963554.0
2018-03-21 15:30:00	SPY	ETF	271.32	271.84	270.41	270.43	10198119.0
2018-03-21 16:00:00	SPY	ETF	270.41	270.8	270.38	270.54	5603155.0
2018-03-21 16:30:00	SPY	ETF	270.61	270.71	270.43	270.69	327807.0
2018-03-21 17:00:00	SPY	ETF	270.62	270.68	270.61	270.65	11654.0
2018-03-21 17:30:00	SPY	ETF	270.66	270.67	270.62	270.67	21919.0
2018-03-21 18:00:00	SPY	ETF	270.68	270.9	270.68	270.72	129248.0
2018-03-21 18:30:00	SPY	ETF	270.74	270.86	270.71	270.73	9696.0
2018-03-21 19:00:00	SPY	ETF	270.73	270.76	270.6	270.71	8398.0
2018-03-21 19:30:00	SPY	ETF	270.74	270.75	270.68	270.75	23474.0
2018-03-21 04:00:00	QQQ	ETF	167.74	167.74	167.57	167.57	3200.0
2018-03-21 04:30:00	QQQ	ETF	167.53	167.54	167.32	167.32	38900.0
2018-03-21 05:00:00	QQQ	ETF	167.36	167.41	167.14	167.14	13366.0
2018-03-21 05:30:00	QQQ	ETF	167.28	167.33	167.23	167.29	8200.0
2018-03-21 06:00:00	QQQ	ETF	167.44	167.44	167.28	167.42	15700.0
2018-03-21 06:30:00	QQQ	ETF	167.45	167.56	167.38	167.39	8000.0
2018-03-21 07:00:00	QQQ	ETF	167.36	167.54	167.32	167.48	16841.0
2018-03-21 07:30:00	QQQ	ETF	167.44	167.51	167.11	167.29	83162.0
2018-03-21 08:00:00	QQQ	ETF	167.35	167.51	167.19	167.45	286456.0
2018-03-21 08:30:00	QQQ	ETF	167.44	167.47	167.24	167.47	164672.0
2018-03-21 09:00:00	QQQ	ETF	167.47	167.47	167.12	167.22	79837.0
2018-03-21 09:30:00	QQQ	ETF	167.23	167.58	167.02	167.4088	2607057.0
2018-03-21 10:00:00	QQQ	ETF	167.42	167.99	167.41	167.56	2100028.0
2018-03-21 10:30:00	QQQ	ETF	167.56	167.75	167.32	167.45	1810527.0
2018-03-21 11:00:00	QQQ	ETF	167.45	167.79	167.35	167.7	798075.0
2018-03-21 11:30:00	QQQ	ETF	167.69	168.22	167.67	168.04	1273673.0
2018-03-21 12:00:00	QQQ	ETF	168.03	168.09	167.91	168.0393	769080.0
2018-03-21 12:30:00	QQQ	ETF	168.05	168.24	168.0	168.2	486049.0

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

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