PREVIEW / etf_30min / 2017-07-07

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-07-07.parquet
  size:    423 KB
  rows:    14,791

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
2017-07-07 04:00:00	SPY	ETF	240.75	240.82	240.71	240.8	5775.0
2017-07-07 04:30:00	SPY	ETF	240.75	240.75	240.68	240.68	4050.0
2017-07-07 05:00:00	SPY	ETF	240.68	240.81	240.68	240.74	9338.0
2017-07-07 05:30:00	SPY	ETF	240.7	240.7	240.63	240.63	3384.0
2017-07-07 06:00:00	SPY	ETF	240.75	240.78	240.72	240.78	13582.0
2017-07-07 06:30:00	SPY	ETF	240.83	240.85	240.77	240.77	75508.0
2017-07-07 07:00:00	SPY	ETF	240.76	240.76	240.67	240.67	11455.0
2017-07-07 07:30:00	SPY	ETF	240.65	240.74	240.65	240.69	31609.0
2017-07-07 08:00:00	SPY	ETF	240.69	240.95	240.66	240.87	210953.0
2017-07-07 08:30:00	SPY	ETF	240.87	241.54	240.79	241.14	952127.0
2017-07-07 09:00:00	SPY	ETF	241.15	241.28	241.0	241.21	453317.0
2017-07-07 09:30:00	SPY	ETF	241.21	241.56	241.02	241.49	5242000.0
2017-07-07 10:00:00	SPY	ETF	241.48	241.51	241.05	241.37	2832120.0
2017-07-07 10:30:00	SPY	ETF	241.37	241.58	241.27	241.31	2257333.0
2017-07-07 11:00:00	SPY	ETF	241.31	241.785	241.23	241.7101	3852342.0
2017-07-07 11:30:00	SPY	ETF	241.72	242.0301	241.7	241.94	3180361.0
2017-07-07 12:00:00	SPY	ETF	241.94	242.21	241.921	242.105	2172493.0
2017-07-07 12:30:00	SPY	ETF	242.11	242.2	242.08	242.15	1701015.0
2017-07-07 13:00:00	SPY	ETF	242.14	242.23	242.085	242.2	1389673.0
2017-07-07 13:30:00	SPY	ETF	242.195	242.28	242.1	242.2	1110869.0
2017-07-07 14:00:00	SPY	ETF	242.2	242.27	242.04	242.0659	2306875.0
2017-07-07 14:30:00	SPY	ETF	242.06	242.14	242.0214	242.04	1676796.0
2017-07-07 15:00:00	SPY	ETF	242.04	242.13	241.94	242.11	2469679.0
2017-07-07 15:30:00	SPY	ETF	242.1	242.26	242.02	242.1	11205030.0
2017-07-07 16:00:00	SPY	ETF	242.1	242.16	242.0	242.07	10790937.0
2017-07-07 16:30:00	SPY	ETF	242.07	242.15	241.8174	242.1	336371.0
2017-07-07 17:00:00	SPY	ETF	242.09	242.12	242.05	242.08	273486.0
2017-07-07 17:30:00	SPY	ETF	242.08	242.11	242.05	242.05	819021.0
2017-07-07 18:00:00	SPY	ETF	242.06	242.08	242.06	242.07	9878.0
2017-07-07 18:30:00	SPY	ETF	242.03	242.07	242.03	242.07	38223.0
2017-07-07 19:00:00	SPY	ETF	242.03	242.05	242.02	242.05	17072.0
2017-07-07 19:30:00	SPY	ETF	242.05	242.07	242.05	242.06	7604.0
2017-07-07 04:00:00	QQQ	ETF	136.25	136.26	136.22	136.22	5347.0
2017-07-07 04:30:00	QQQ	ETF	136.37	136.37	136.37	136.37	100.0
2017-07-07 05:00:00	QQQ	ETF	136.34	136.34	136.3	136.3	3799.0
2017-07-07 05:30:00	QQQ	ETF	136.28	136.28	136.19	136.19	3200.0
2017-07-07 06:00:00	QQQ	ETF	136.33	136.43	136.31	136.43	2200.0
2017-07-07 06:30:00	QQQ	ETF	136.44	136.5	136.37	136.39	72285.0
2017-07-07 07:00:00	QQQ	ETF	136.38	136.49	136.37	136.39	13003.0
2017-07-07 07:30:00	QQQ	ETF	136.38	136.39	136.3	136.34	17179.0
2017-07-07 08:00:00	QQQ	ETF	136.31	136.53	136.3	136.52	61564.0
2017-07-07 08:30:00	QQQ	ETF	136.52	137.13	136.52	136.68	423749.0
2017-07-07 09:00:00	QQQ	ETF	136.69	136.79	136.6	136.74	139870.0
2017-07-07 09:30:00	QQQ	ETF	136.74	137.395	136.74	137.35	6081047.0
2017-07-07 10:00:00	QQQ	ETF	137.34	137.39	136.99	137.3	2260079.0
2017-07-07 10:30:00	QQQ	ETF	137.3	137.46	137.2	137.21	3041758.0
2017-07-07 11:00:00	QQQ	ETF	137.22	137.6111	137.14	137.535	1418451.0
2017-07-07 11:30:00	QQQ	ETF	137.54	137.79	137.535	137.68	2069681.0
2017-07-07 12:00:00	QQQ	ETF	137.69	137.88	137.64	137.77	986758.0
2017-07-07 12:30:00	QQQ	ETF	137.77	137.85	137.7451	137.805	628171.0

> showing 50 of 14,791 rows — these rows as CSV

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