PREVIEW / etf_30min / 2015-11-19

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-11-19.parquet
  size:    381 KB
  rows:    12,834

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-11-19 04:00:00	SPY	ETF	209.04	209.33	209.04	209.33	3327.0
2015-11-19 04:30:00	SPY	ETF	209.33	209.4	209.26	209.4	9740.0
2015-11-19 05:00:00	SPY	ETF	209.42	209.45	209.37	209.44	15635.0
2015-11-19 05:30:00	SPY	ETF	209.39	209.46	209.32	209.4	6043.0
2015-11-19 06:00:00	SPY	ETF	209.37	209.55	209.35	209.4	41478.0
2015-11-19 06:30:00	SPY	ETF	209.42	209.6	209.37	209.37	36575.0
2015-11-19 07:00:00	SPY	ETF	209.36	209.46	209.27	209.35	108506.0
2015-11-19 07:30:00	SPY	ETF	209.36	209.38	209.04	209.11	198878.0
2015-11-19 08:00:00	SPY	ETF	209.08	209.42	208.95	209.13	306756.0
2015-11-19 08:30:00	SPY	ETF	209.13	209.29	208.79	208.85	560093.0
2015-11-19 09:00:00	SPY	ETF	208.85	208.92	208.54	208.58	496584.0
2015-11-19 09:30:00	SPY	ETF	208.59	209.05	208.39	208.88	13940377.0
2015-11-19 10:00:00	SPY	ETF	208.87	209.0499	208.45	208.575	8740879.0
2015-11-19 10:30:00	SPY	ETF	208.5701	208.8	208.31	208.59	8366234.0
2015-11-19 11:00:00	SPY	ETF	208.59	208.91	208.45	208.82	4832412.0
2015-11-19 11:30:00	SPY	ETF	208.81	208.87	208.2	208.33	4904650.0
2015-11-19 12:00:00	SPY	ETF	208.33	208.5	208.3	208.445	3560284.0
2015-11-19 12:30:00	SPY	ETF	208.44	208.91	208.42	208.87	3500320.0
2015-11-19 13:00:00	SPY	ETF	208.87	209.0	208.81	208.83	2948956.0
2015-11-19 13:30:00	SPY	ETF	208.83	208.96	208.65	208.67	3673513.0
2015-11-19 14:00:00	SPY	ETF	208.67	208.7	208.4	208.58	2832355.0
2015-11-19 14:30:00	SPY	ETF	208.58	208.77	208.425	208.62	2919128.0
2015-11-19 15:00:00	SPY	ETF	208.63	208.81	208.37	208.76	4380111.0
2015-11-19 15:30:00	SPY	ETF	208.77	208.82	208.42	208.53	11058089.0
2015-11-19 16:00:00	SPY	ETF	208.53	208.68	208.4793	208.63	4768509.0
2015-11-19 16:30:00	SPY	ETF	208.63	208.69	208.55	208.61	248434.0
2015-11-19 17:00:00	SPY	ETF	208.61	208.63	208.53	208.59	4484082.0
2015-11-19 17:30:00	SPY	ETF	208.56	208.6	208.5	208.5	63938.0
2015-11-19 18:00:00	SPY	ETF	208.51	208.54	208.29	208.38	152928.0
2015-11-19 18:30:00	SPY	ETF	208.41	208.48	208.38	208.39	93024.0
2015-11-19 19:00:00	SPY	ETF	208.38	208.41	208.29	208.31	17250.0
2015-11-19 19:30:00	SPY	ETF	208.34	208.41	208.32	208.41	58320.0
2015-11-19 04:00:00	QQQ	ETF	113.8	113.9	113.8	113.9	400.0
2015-11-19 04:30:00	QQQ	ETF	113.97	114.04	113.95	114.04	13100.0
2015-11-19 05:00:00	QQQ	ETF	114.05	114.05	114.05	114.05	200.0
2015-11-19 06:00:00	QQQ	ETF	114.05	114.06	114.04	114.06	3400.0
2015-11-19 06:30:00	QQQ	ETF	114.06	114.13	114.02	114.02	2600.0
2015-11-19 07:00:00	QQQ	ETF	114.03	114.07	114.03	114.06	24500.0
2015-11-19 07:30:00	QQQ	ETF	114.06	114.06	113.97	113.98	4540.0
2015-11-19 08:00:00	QQQ	ETF	114.03	114.03	113.88	113.91	22686.0
2015-11-19 08:30:00	QQQ	ETF	113.94	114.01	113.74	113.78	179960.0
2015-11-19 09:00:00	QQQ	ETF	113.78	113.82	113.61	113.66	209139.0
2015-11-19 09:30:00	QQQ	ETF	113.68	113.92	113.49	113.8375	3819020.0
2015-11-19 10:00:00	QQQ	ETF	113.84	113.97	113.592	113.71	2810543.0
2015-11-19 10:30:00	QQQ	ETF	113.71	113.82	113.54	113.781	1783391.0
2015-11-19 11:00:00	QQQ	ETF	113.78	114.03	113.6288	114.0	1919831.0
2015-11-19 11:30:00	QQQ	ETF	113.99	114.04	113.65	113.77	1248844.0
2015-11-19 12:00:00	QQQ	ETF	113.77	113.96	113.76	113.94	1158846.0
2015-11-19 12:30:00	QQQ	ETF	113.94	114.135	113.89	114.12	1149500.0
2015-11-19 13:00:00	QQQ	ETF	114.12	114.23	114.085	114.0917	1489604.0

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

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