PREVIEW / etf_30min / 2017-04-20

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-04-20.parquet
  size:    432 KB
  rows:    14,764

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-04-20 04:00:00	SPY	ETF	233.84	234.1	233.84	233.84	9500.0
2017-04-20 04:30:00	SPY	ETF	233.96	234.06	233.96	234.05	9775.0
2017-04-20 05:00:00	SPY	ETF	233.92	234.2	233.92	234.2	8820.0
2017-04-20 05:30:00	SPY	ETF	234.1	234.11	234.06	234.07	3700.0
2017-04-20 06:00:00	SPY	ETF	234.06	234.11	233.99	233.99	5647.0
2017-04-20 06:30:00	SPY	ETF	234.02	234.08	234.02	234.07	6550.0
2017-04-20 07:00:00	SPY	ETF	234.07	234.11	233.96	234.0	28282.0
2017-04-20 07:30:00	SPY	ETF	234.06	234.12	234.01	234.02	45952.0
2017-04-20 08:00:00	SPY	ETF	234.03	234.15	233.98	234.09	142227.0
2017-04-20 08:30:00	SPY	ETF	234.1	234.18	233.98	234.05	172410.0
2017-04-20 09:00:00	SPY	ETF	234.04	234.2	234.0	234.15	406315.0
2017-04-20 09:30:00	SPY	ETF	234.15	234.3	233.78	233.9099	6526366.0
2017-04-20 10:00:00	SPY	ETF	233.9	234.4699	233.9	234.2	5392477.0
2017-04-20 10:30:00	SPY	ETF	234.19	234.42	234.05	234.35	3557198.0
2017-04-20 11:00:00	SPY	ETF	234.35	234.54	234.17	234.51	5003894.0
2017-04-20 11:30:00	SPY	ETF	234.52	234.94	234.48	234.9	5989156.0
2017-04-20 12:00:00	SPY	ETF	234.9	235.32	234.87	235.16	6811980.0
2017-04-20 12:30:00	SPY	ETF	235.16	235.44	235.14	235.285	4070162.0
2017-04-20 13:00:00	SPY	ETF	235.283	235.41	235.14	235.3511	5000814.0
2017-04-20 13:30:00	SPY	ETF	235.36	235.845	235.34	235.74	6792402.0
2017-04-20 14:00:00	SPY	ETF	235.74	235.77	235.5	235.63	5277365.0
2017-04-20 14:30:00	SPY	ETF	235.63	235.75	235.5	235.51	5060291.0
2017-04-20 15:00:00	SPY	ETF	235.505	235.64	235.3	235.49	6929914.0
2017-04-20 15:30:00	SPY	ETF	235.49	235.69	235.27	235.3	14151144.0
2017-04-20 16:00:00	SPY	ETF	235.3	235.626	235.18	235.21	7872786.0
2017-04-20 16:30:00	SPY	ETF	235.22	235.34	235.18	235.24	1333544.0
2017-04-20 17:00:00	SPY	ETF	235.24	235.34	235.19	235.22	91839.0
2017-04-20 17:30:00	SPY	ETF	235.21	235.28	235.21	235.28	28902.0
2017-04-20 18:00:00	SPY	ETF	235.26	235.38	235.24	235.37	126465.0
2017-04-20 18:30:00	SPY	ETF	235.35	235.36	235.32	235.32	58514.0
2017-04-20 19:00:00	SPY	ETF	235.32	235.36	235.3	235.3	40784.0
2017-04-20 19:30:00	SPY	ETF	235.32	235.33	235.3	235.32	10661.0
2017-04-20 04:00:00	QQQ	ETF	131.73	131.92	131.73	131.81	3250.0
2017-04-20 04:30:00	QQQ	ETF	131.85	131.85	131.85	131.85	100.0
2017-04-20 05:00:00	QQQ	ETF	131.88	131.88	131.88	131.88	100.0
2017-04-20 06:30:00	QQQ	ETF	131.95	131.95	131.95	131.95	3000.0
2017-04-20 07:00:00	QQQ	ETF	131.89	131.9	131.88	131.88	19000.0
2017-04-20 07:30:00	QQQ	ETF	131.93	131.97	131.93	131.95	17224.0
2017-04-20 08:00:00	QQQ	ETF	131.93	132.03	131.91	132.0	39375.0
2017-04-20 08:30:00	QQQ	ETF	131.98	132.06	131.95	131.98	38699.0
2017-04-20 09:00:00	QQQ	ETF	131.97	132.06	131.97	132.03	81479.0
2017-04-20 09:30:00	QQQ	ETF	132.04	132.21	131.82	131.88	1997594.0
2017-04-20 10:00:00	QQQ	ETF	131.88	132.27	131.88	132.08	1942129.0
2017-04-20 10:30:00	QQQ	ETF	132.07	132.14	131.93	132.0965	866483.0
2017-04-20 11:00:00	QQQ	ETF	132.1	132.205	132.02	132.18	589299.0
2017-04-20 11:30:00	QQQ	ETF	132.19	132.4184	132.12	132.39	1093789.0
2017-04-20 12:00:00	QQQ	ETF	132.39	132.69	132.37	132.6	1428705.0
2017-04-20 12:30:00	QQQ	ETF	132.6	132.788	132.59	132.68	785089.0
2017-04-20 13:00:00	QQQ	ETF	132.68	132.78	132.57	132.68	522330.0
2017-04-20 13:30:00	QQQ	ETF	132.69	132.88	132.67	132.819	1256873.0

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

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