PREVIEW / etf_30min / 2017-07-05

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-07-05.parquet
  size:    431 KB
  rows:    15,104

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-05 04:00:00	SPY	ETF	242.25	242.33	242.12	242.12	4450.0
2017-07-05 04:30:00	SPY	ETF	242.13	242.24	242.07	242.24	5929.0
2017-07-05 05:00:00	SPY	ETF	242.3	242.32	242.3	242.32	2450.0
2017-07-05 05:30:00	SPY	ETF	242.22	242.22	242.22	242.22	1630.0
2017-07-05 06:00:00	SPY	ETF	242.2	242.27	242.17	242.27	4794.0
2017-07-05 06:30:00	SPY	ETF	242.25	242.45	242.25	242.4	16643.0
2017-07-05 07:00:00	SPY	ETF	242.42	242.45	242.34	242.36	39568.0
2017-07-05 07:30:00	SPY	ETF	242.38	242.54	242.3	242.53	59802.0
2017-07-05 08:00:00	SPY	ETF	242.4	242.66	242.021	242.66	110526.0
2017-07-05 08:30:00	SPY	ETF	242.65	242.71	242.6	242.61	171916.0
2017-07-05 09:00:00	SPY	ETF	242.6	242.72	242.5	242.61	324694.0
2017-07-05 09:30:00	SPY	ETF	242.63	242.71	242.05	242.21	7242262.0
2017-07-05 10:00:00	SPY	ETF	242.21	242.22	241.7	241.955	5716718.0
2017-07-05 10:30:00	SPY	ETF	241.965	242.5	241.88	242.46	3975862.0
2017-07-05 11:00:00	SPY	ETF	242.47	242.74	242.44	242.64	2689372.0
2017-07-05 11:30:00	SPY	ETF	242.64	242.64	242.4	242.43	2234850.0
2017-07-05 12:00:00	SPY	ETF	242.43	242.66	242.38	242.56	1853750.0
2017-07-05 12:30:00	SPY	ETF	242.57	242.73	242.54	242.685	2042106.0
2017-07-05 13:00:00	SPY	ETF	242.69	242.88	242.66	242.77	1901369.0
2017-07-05 13:30:00	SPY	ETF	242.775	242.84	242.61	242.6504	1661813.0
2017-07-05 14:00:00	SPY	ETF	242.65	242.91	242.44	242.8899	2692962.0
2017-07-05 14:30:00	SPY	ETF	242.87	243.01	242.57	242.61	3015436.0
2017-07-05 15:00:00	SPY	ETF	242.61	242.79	242.44	242.74	3243954.0
2017-07-05 15:30:00	SPY	ETF	242.74	242.94	242.71	242.77	7541605.0
2017-07-05 16:00:00	SPY	ETF	242.77	242.77	242.51	242.55	5361197.0
2017-07-05 16:30:00	SPY	ETF	242.56	242.77	242.56	242.62	208673.0
2017-07-05 17:00:00	SPY	ETF	242.62	242.77	242.55	242.6	136615.0
2017-07-05 17:30:00	SPY	ETF	242.77	242.77	242.59	242.6	255061.0
2017-07-05 18:00:00	SPY	ETF	242.59	242.66	242.54	242.62	56152.0
2017-07-05 18:30:00	SPY	ETF	242.62	242.78	242.62	242.76	70213.0
2017-07-05 19:00:00	SPY	ETF	242.74	242.74	242.74	242.74	900.0
2017-07-05 19:30:00	SPY	ETF	242.74	242.76	242.72	242.76	6875.0
2017-07-05 04:00:00	QQQ	ETF	136.05	136.24	135.54	135.54	4444.0
2017-07-05 04:30:00	QQQ	ETF	135.58	135.62	135.58	135.61	1100.0
2017-07-05 05:00:00	QQQ	ETF	135.69	135.69	135.67	135.67	287.0
2017-07-05 05:30:00	QQQ	ETF	135.61	135.7	135.61	135.7	1130.0
2017-07-05 06:00:00	QQQ	ETF	135.63	135.66	135.63	135.66	800.0
2017-07-05 06:30:00	QQQ	ETF	135.67	135.71	135.67	135.7	28240.0
2017-07-05 07:00:00	QQQ	ETF	135.71	135.71	135.64	135.71	6746.0
2017-07-05 07:30:00	QQQ	ETF	135.7	136.28	135.7	136.27	85491.0
2017-07-05 08:00:00	QQQ	ETF	136.27	136.47	135.71	136.47	124202.0
2017-07-05 08:30:00	QQQ	ETF	136.48	136.59	136.23	136.51	125058.0
2017-07-05 09:00:00	QQQ	ETF	136.51	136.71	136.45	136.59	214017.0
2017-07-05 09:30:00	QQQ	ETF	136.57	137.03	136.37	136.58	6151844.0
2017-07-05 10:00:00	QQQ	ETF	136.58	136.59	136.16	136.44	3965802.0
2017-07-05 10:30:00	QQQ	ETF	136.435	137.1699	136.425	137.06	3193180.0
2017-07-05 11:00:00	QQQ	ETF	137.06	137.36	136.98	137.325	1384147.0
2017-07-05 11:30:00	QQQ	ETF	137.32	137.33	137.06	137.16	1045475.0
2017-07-05 12:00:00	QQQ	ETF	137.16	137.42	137.13	137.34	1265373.0
2017-07-05 12:30:00	QQQ	ETF	137.335	137.4497	137.26	137.4075	659199.0

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

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