PREVIEW / etf_30min / 2015-08-05

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-08-05.parquet
  size:    375 KB
  rows:    12,606

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-08-05 04:00:00	SPY	ETF	209.35	209.35	209.27	209.3	1125.0
2015-08-05 04:30:00	SPY	ETF	209.42	209.54	209.42	209.54	3834.0
2015-08-05 05:00:00	SPY	ETF	209.54	209.54	209.54	209.54	600.0
2015-08-05 05:30:00	SPY	ETF	209.53	209.72	209.51	209.7	3984.0
2015-08-05 06:00:00	SPY	ETF	209.7	209.83	209.7	209.74	38358.0
2015-08-05 06:30:00	SPY	ETF	209.85	209.98	209.81	209.91	136920.0
2015-08-05 07:00:00	SPY	ETF	209.87	210.32	209.86	210.28	363250.0
2015-08-05 07:30:00	SPY	ETF	210.26	210.42	210.18	210.22	273596.0
2015-08-05 08:00:00	SPY	ETF	210.2	210.94	209.87	210.7	1226110.0
2015-08-05 08:30:00	SPY	ETF	210.7	210.76	210.48	210.48	830960.0
2015-08-05 09:00:00	SPY	ETF	210.48	210.56	210.39	210.45	885056.0
2015-08-05 09:30:00	SPY	ETF	210.45	211.09	210.4	210.9098	12120970.0
2015-08-05 10:00:00	SPY	ETF	210.93	211.27	210.66	211.22	7704508.0
2015-08-05 10:30:00	SPY	ETF	211.23	211.31	210.98	211.04	5402065.0
2015-08-05 11:00:00	SPY	ETF	211.045	211.17	210.93	211.11	4808317.0
2015-08-05 11:30:00	SPY	ETF	211.11	211.17	210.48	210.53	6029365.0
2015-08-05 12:00:00	SPY	ETF	210.52	210.58	210.14	210.21	5497876.0
2015-08-05 12:30:00	SPY	ETF	210.21	210.34	209.9	210.33	5845803.0
2015-08-05 13:00:00	SPY	ETF	210.34	210.35	209.73	209.99	3713079.0
2015-08-05 13:30:00	SPY	ETF	209.98	210.12	209.78	209.95	4707898.0
2015-08-05 14:00:00	SPY	ETF	209.94	210.33	209.86	210.29	3148413.0
2015-08-05 14:30:00	SPY	ETF	210.29	210.4	210.14	210.235	3602576.0
2015-08-05 15:00:00	SPY	ETF	210.24	210.51	210.185	210.25	5724609.0
2015-08-05 15:30:00	SPY	ETF	210.24	210.2492	209.99	210.09	7854887.0
2015-08-05 16:00:00	SPY	ETF	210.08	210.26	209.98	210.08	3444147.0
2015-08-05 16:30:00	SPY	ETF	210.08	211.37	209.98	210.09	1557777.0
2015-08-05 17:00:00	SPY	ETF	210.09	210.13	210.01	210.05	284672.0
2015-08-05 17:30:00	SPY	ETF	210.06	210.06	210.02	210.02	14100.0
2015-08-05 18:00:00	SPY	ETF	210.02	210.06	209.97	209.98	50750.0
2015-08-05 18:30:00	SPY	ETF	209.98	210.0	209.98	209.98	15800.0
2015-08-05 19:00:00	SPY	ETF	209.99	210.01	209.97	209.98	85650.0
2015-08-05 19:30:00	SPY	ETF	209.98	210.01	209.92	209.93	34806.0
2015-08-05 06:00:00	QQQ	ETF	111.53	111.53	111.49	111.49	6600.0
2015-08-05 06:30:00	QQQ	ETF	111.59	111.64	111.52	111.52	24200.0
2015-08-05 07:00:00	QQQ	ETF	111.62	111.88	111.6	111.88	28300.0
2015-08-05 07:30:00	QQQ	ETF	111.9	111.96	111.85	111.88	12000.0
2015-08-05 08:00:00	QQQ	ETF	111.86	112.36	111.61	112.25	227493.0
2015-08-05 08:30:00	QQQ	ETF	112.23	112.24	112.03	112.03	193985.0
2015-08-05 09:00:00	QQQ	ETF	112.03	112.1	111.99	112.01	121339.0
2015-08-05 09:30:00	QQQ	ETF	112.01	112.71	111.88	112.65	5245320.0
2015-08-05 10:00:00	QQQ	ETF	112.65	112.805	112.5	112.7499	2530004.0
2015-08-05 10:30:00	QQQ	ETF	112.76	112.8899	112.67	112.84	1760548.0
2015-08-05 11:00:00	QQQ	ETF	112.84	112.98	112.78	112.94	1483666.0
2015-08-05 11:30:00	QQQ	ETF	112.931	113.0	112.69	112.72	1456633.0
2015-08-05 12:00:00	QQQ	ETF	112.715	112.72	112.42	112.45	2275978.0
2015-08-05 12:30:00	QQQ	ETF	112.45	112.56	112.25	112.55	1577277.0
2015-08-05 13:00:00	QQQ	ETF	112.55	112.56	112.15	112.2851	1532051.0
2015-08-05 13:30:00	QQQ	ETF	112.28	112.33	112.07	112.16	1069960.0
2015-08-05 14:00:00	QQQ	ETF	112.16	112.33	112.12	112.3	702853.0
2015-08-05 14:30:00	QQQ	ETF	112.31	112.53	112.3	112.35	1399233.0

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

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