PREVIEW / etf_30min / 2015-12-01

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-12-01.parquet
  size:    385 KB
  rows:    13,049

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-12-01 04:00:00	SPY	ETF	209.43	209.44	209.32	209.4	4250.0
2015-12-01 04:30:00	SPY	ETF	209.35	209.35	209.24	209.3	26125.0
2015-12-01 05:00:00	SPY	ETF	209.3	209.31	209.08	209.16	44537.0
2015-12-01 05:30:00	SPY	ETF	209.13	209.36	209.07	209.36	9953.0
2015-12-01 06:00:00	SPY	ETF	209.37	209.65	209.37	209.6	15261.0
2015-12-01 06:30:00	SPY	ETF	209.55	209.6	209.4	209.44	29143.0
2015-12-01 07:00:00	SPY	ETF	209.45	209.46	209.33	209.34	33047.0
2015-12-01 07:30:00	SPY	ETF	209.34	209.59	209.34	209.51	78059.0
2015-12-01 08:00:00	SPY	ETF	209.52	209.67	209.41	209.43	178967.0
2015-12-01 08:30:00	SPY	ETF	209.42	209.44	209.27	209.32	247266.0
2015-12-01 09:00:00	SPY	ETF	209.32	209.56	209.31	209.43	354261.0
2015-12-01 09:30:00	SPY	ETF	209.44	210.39	209.36	210.24	12655158.0
2015-12-01 10:00:00	SPY	ETF	210.23	210.26	209.11	209.515	13131127.0
2015-12-01 10:30:00	SPY	ETF	209.51	210.065	209.31	209.89	7329980.0
2015-12-01 11:00:00	SPY	ETF	209.9	209.975	209.6	209.75	5777124.0
2015-12-01 11:30:00	SPY	ETF	209.75	209.8699	209.47	209.725	4717805.0
2015-12-01 12:00:00	SPY	ETF	209.725	209.95	209.69	209.84	3377084.0
2015-12-01 12:30:00	SPY	ETF	209.85	210.12	209.8	210.055	4282878.0
2015-12-01 13:00:00	SPY	ETF	210.0501	210.06	209.7	209.74	2867456.0
2015-12-01 13:30:00	SPY	ETF	209.74	209.77	209.53	209.66	3371562.0
2015-12-01 14:00:00	SPY	ETF	209.67	210.1	209.64	210.0585	6871127.0
2015-12-01 14:30:00	SPY	ETF	210.05	210.2	209.96	210.045	4555631.0
2015-12-01 15:00:00	SPY	ETF	210.05	210.32	210.025	210.3	4974600.0
2015-12-01 15:30:00	SPY	ETF	210.31	210.82	210.25	210.74	16530571.0
2015-12-01 16:00:00	SPY	ETF	210.74	210.77	210.64	210.66	4209665.0
2015-12-01 16:30:00	SPY	ETF	210.66	210.69	210.61	210.64	286898.0
2015-12-01 17:00:00	SPY	ETF	210.66	210.69	210.64	210.69	47753.0
2015-12-01 17:30:00	SPY	ETF	210.67	210.71	210.63	210.63	156839.0
2015-12-01 18:00:00	SPY	ETF	210.62	210.68	210.58	210.6	116469.0
2015-12-01 18:30:00	SPY	ETF	210.62	210.62	210.48	210.48	48438.0
2015-12-01 19:00:00	SPY	ETF	210.51	210.61	210.49	210.6	23394.0
2015-12-01 19:30:00	SPY	ETF	210.6	210.63	210.52	210.62	56887.0
2015-12-01 04:00:00	QQQ	ETF	114.4	114.4	114.4	114.4	1000.0
2015-12-01 06:00:00	QQQ	ETF	114.53	114.53	114.53	114.53	2000.0
2015-12-01 06:30:00	QQQ	ETF	114.5	114.52	114.49	114.49	3500.0
2015-12-01 07:00:00	QQQ	ETF	114.51	114.51	114.38	114.38	6321.0
2015-12-01 07:30:00	QQQ	ETF	114.41	114.5	114.41	114.5	4068.0
2015-12-01 08:00:00	QQQ	ETF	114.49	114.52	114.42	114.42	28477.0
2015-12-01 08:30:00	QQQ	ETF	114.42	114.44	114.4	114.41	16299.0
2015-12-01 09:00:00	QQQ	ETF	114.45	114.57	114.45	114.47	97547.0
2015-12-01 09:30:00	QQQ	ETF	114.475	115.0	114.34	114.99	3854621.0
2015-12-01 10:00:00	QQQ	ETF	114.98	115.0	114.25	114.49	3707910.0
2015-12-01 10:30:00	QQQ	ETF	114.48	114.9585	114.355	114.82	2804014.0
2015-12-01 11:00:00	QQQ	ETF	114.82	114.89	114.64	114.73	1507384.0
2015-12-01 11:30:00	QQQ	ETF	114.74	114.81	114.55	114.71	854548.0
2015-12-01 12:00:00	QQQ	ETF	114.71	114.9	114.705	114.87	910937.0
2015-12-01 12:30:00	QQQ	ETF	114.88	114.94	114.79	114.89	683305.0
2015-12-01 13:00:00	QQQ	ETF	114.88	114.895	114.6	114.62	1020438.0
2015-12-01 13:30:00	QQQ	ETF	114.63	114.66	113.9108	114.5849	2487219.0
2015-12-01 14:00:00	QQQ	ETF	114.585	114.82	114.56	114.77	845865.0

> showing 50 of 13,049 rows — these rows as CSV

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