PREVIEW / etf_30min / 2015-04-13

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-04-13.parquet
  size:    382 KB
  rows:    12,755

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
2015-04-13 04:00:00	SPY	ETF	209.77	210.14	209.5	209.5	2326.0
2015-04-13 04:30:00	SPY	ETF	209.54	209.57	209.54	209.57	300.0
2015-04-13 05:00:00	SPY	ETF	209.63	209.68	209.58	209.65	2500.0
2015-04-13 05:30:00	SPY	ETF	209.65	209.86	209.58	209.85	9800.0
2015-04-13 06:00:00	SPY	ETF	209.85	209.85	209.73	209.73	24173.0
2015-04-13 06:30:00	SPY	ETF	209.76	209.86	209.71	209.71	27539.0
2015-04-13 07:00:00	SPY	ETF	209.75	209.84	209.67	209.78	102105.0
2015-04-13 07:30:00	SPY	ETF	209.78	209.78	209.6	209.62	143862.0
2015-04-13 08:00:00	SPY	ETF	209.64	209.83	209.62	209.65	305884.0
2015-04-13 08:30:00	SPY	ETF	209.65	210.07	209.51	209.65	259018.0
2015-04-13 09:00:00	SPY	ETF	209.63	209.88	209.61	209.87	400078.0
2015-04-13 09:30:00	SPY	ETF	209.87	210.5	209.84	210.45	9361644.0
2015-04-13 10:00:00	SPY	ETF	210.45	210.63	210.2934	210.49	3485501.0
2015-04-13 10:30:00	SPY	ETF	210.5	210.58	210.2	210.22	3156566.0
2015-04-13 11:00:00	SPY	ETF	210.21	210.41	210.18	210.24	6344884.0
2015-04-13 11:30:00	SPY	ETF	210.24	210.44	210.14	210.16	5126450.0
2015-04-13 12:00:00	SPY	ETF	210.1628	210.21	209.87	209.975	4307877.0
2015-04-13 12:30:00	SPY	ETF	209.975	210.12	209.915	210.05	3070651.0
2015-04-13 13:00:00	SPY	ETF	210.05	210.05	209.55	209.5899	4911486.0
2015-04-13 13:30:00	SPY	ETF	209.585	209.72	209.375	209.66	4967907.0
2015-04-13 14:00:00	SPY	ETF	209.66	209.76	209.51	209.61	3440341.0
2015-04-13 14:30:00	SPY	ETF	209.62	209.78	209.27	209.44	3658736.0
2015-04-13 15:00:00	SPY	ETF	209.445	209.65	209.09	209.1969	3990861.0
2015-04-13 15:30:00	SPY	ETF	209.2	209.41	209.03	209.08	8272769.0
2015-04-13 16:00:00	SPY	ETF	209.11	209.2	209.04	209.16	3152304.0
2015-04-13 16:30:00	SPY	ETF	209.16	209.16	209.0663	209.16	1257209.0
2015-04-13 17:00:00	SPY	ETF	209.17	209.28	209.17	209.27	75311.0
2015-04-13 17:30:00	SPY	ETF	209.26	209.28	209.19	209.2	137008.0
2015-04-13 18:00:00	SPY	ETF	209.19	209.27	209.12	209.14	123826.0
2015-04-13 18:30:00	SPY	ETF	209.13	209.18	209.13	209.16	6200.0
2015-04-13 19:00:00	SPY	ETF	209.16	209.19	209.14	209.179	12961.0
2015-04-13 19:30:00	SPY	ETF	209.18	209.2	209.17	209.19	21371.0
2015-04-13 04:00:00	QQQ	ETF	107.6	107.6	107.6	107.6	400.0
2015-04-13 06:00:00	QQQ	ETF	107.65	107.65	107.65	107.65	400.0
2015-04-13 06:30:00	QQQ	ETF	107.65	107.69	107.65	107.68	11200.0
2015-04-13 07:00:00	QQQ	ETF	107.69	107.72	107.67	107.72	9994.0
2015-04-13 07:30:00	QQQ	ETF	107.7	107.72	107.69	107.72	734.0
2015-04-13 08:00:00	QQQ	ETF	107.68	107.76	107.68	107.7	11131.0
2015-04-13 08:30:00	QQQ	ETF	107.66	107.75	107.66	107.73	47268.0
2015-04-13 09:00:00	QQQ	ETF	107.71	107.84	107.71	107.83	110094.0
2015-04-13 09:30:00	QQQ	ETF	107.83	108.31	107.8	108.27	3160023.0
2015-04-13 10:00:00	QQQ	ETF	108.26	108.38	108.2	108.28	1296857.0
2015-04-13 10:30:00	QQQ	ETF	108.29	108.32	108.145	108.16	1196005.0
2015-04-13 11:00:00	QQQ	ETF	108.16	108.27	108.13	108.13	979842.0
2015-04-13 11:30:00	QQQ	ETF	108.14	108.255	108.093	108.13	1157090.0
2015-04-13 12:00:00	QQQ	ETF	108.13	108.17	107.95	108.02	928405.0
2015-04-13 12:30:00	QQQ	ETF	108.02	108.07	107.965	107.98	449224.0
2015-04-13 13:00:00	QQQ	ETF	107.98	107.98	107.65	107.6899	1227186.0
2015-04-13 13:30:00	QQQ	ETF	107.69	107.72	107.48	107.65	869243.0
2015-04-13 14:00:00	QQQ	ETF	107.66	107.76	107.59	107.68	706803.0

> showing 50 of 12,755 rows — these rows as CSV

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