PREVIEW / etf_30min / 2015-12-03

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-12-03.parquet
  size:    398 KB
  rows:    13,264

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-03 04:00:00	SPY	ETF	209.54	209.67	209.37	209.5	11603.0
2015-12-03 04:30:00	SPY	ETF	209.55	210.01	209.55	209.83	62396.0
2015-12-03 05:00:00	SPY	ETF	209.92	210.2	209.83	210.15	63498.0
2015-12-03 05:30:00	SPY	ETF	210.17	210.23	210.07	210.16	25955.0
2015-12-03 06:00:00	SPY	ETF	210.12	210.17	210.0	210.05	10610.0
2015-12-03 06:30:00	SPY	ETF	210.05	210.15	209.96	209.97	42485.0
2015-12-03 07:00:00	SPY	ETF	209.98	210.01	209.75	209.85	136563.0
2015-12-03 07:30:00	SPY	ETF	209.88	210.05	209.09	209.5	1411967.0
2015-12-03 08:00:00	SPY	ETF	209.51	210.02	208.83	209.47	613600.0
2015-12-03 08:30:00	SPY	ETF	209.47	209.76	207.94	208.9	3375569.0
2015-12-03 09:00:00	SPY	ETF	208.84	209.47	208.82	208.83	1993236.0
2015-12-03 09:30:00	SPY	ETF	208.83	209.15	207.93	208.12	16063946.0
2015-12-03 10:00:00	SPY	ETF	208.1038	208.11	207.24	207.535	12697665.0
2015-12-03 10:30:00	SPY	ETF	207.53	208.03	207.28	207.76	7291688.0
2015-12-03 11:00:00	SPY	ETF	207.76	208.38	207.665	208.18	5682376.0
2015-12-03 11:30:00	SPY	ETF	208.1811	208.215	207.5	207.76	5430027.0
2015-12-03 12:00:00	SPY	ETF	207.74	207.8	206.44	206.67	9803768.0
2015-12-03 12:30:00	SPY	ETF	206.669	207.05	206.47	206.5953	7538527.0
2015-12-03 13:00:00	SPY	ETF	206.59	207.0399	206.329	206.92	5548199.0
2015-12-03 13:30:00	SPY	ETF	206.91	206.9625	205.84	205.855	8538816.0
2015-12-03 14:00:00	SPY	ETF	205.855	205.92	205.29	205.365	11518120.0
2015-12-03 14:30:00	SPY	ETF	205.37	205.57	204.7511	205.54	16826445.0
2015-12-03 15:00:00	SPY	ETF	205.54	205.67	204.94	205.085	13583648.0
2015-12-03 15:30:00	SPY	ETF	205.08	205.7499	204.8	205.6	24767591.0
2015-12-03 16:00:00	SPY	ETF	205.58	206.02	205.4247	205.9	8303919.0
2015-12-03 16:30:00	SPY	ETF	205.91	206.16	205.58	206.08	1278784.0
2015-12-03 17:00:00	SPY	ETF	206.08	206.08	205.58	205.99	975865.0
2015-12-03 17:30:00	SPY	ETF	205.98	206.1	205.97	206.03	619184.0
2015-12-03 18:00:00	SPY	ETF	206.07	206.34	206.05	206.22	608815.0
2015-12-03 18:30:00	SPY	ETF	206.19	206.47	206.0	206.0	101181.0
2015-12-03 19:00:00	SPY	ETF	206.1	206.32	206.1	206.3	63913.0
2015-12-03 19:30:00	SPY	ETF	206.25	206.4	206.1	206.37	87975.0
2015-12-03 04:00:00	QQQ	ETF	114.92	115.12	114.92	115.1	1180.0
2015-12-03 04:30:00	QQQ	ETF	115.18	115.38	115.18	115.37	430.0
2015-12-03 05:00:00	QQQ	ETF	115.33	115.52	115.33	115.52	600.0
2015-12-03 05:30:00	QQQ	ETF	115.52	115.52	115.46	115.46	1000.0
2015-12-03 06:00:00	QQQ	ETF	115.46	115.5	115.43	115.5	400.0
2015-12-03 06:30:00	QQQ	ETF	115.4	115.43	115.39	115.39	3500.0
2015-12-03 07:00:00	QQQ	ETF	115.37	115.4	115.3	115.33	10138.0
2015-12-03 07:30:00	QQQ	ETF	115.37	115.38	114.93	115.15	93881.0
2015-12-03 08:00:00	QQQ	ETF	115.12	115.39	114.9	115.0	87075.0
2015-12-03 08:30:00	QQQ	ETF	115.0	115.12	114.2	114.75	365175.0
2015-12-03 09:00:00	QQQ	ETF	114.74	115.07	114.74	114.77	206750.0
2015-12-03 09:30:00	QQQ	ETF	114.76	114.96	114.22	114.39	4557366.0
2015-12-03 10:00:00	QQQ	ETF	114.38	114.5	113.82	113.98	3299493.0
2015-12-03 10:30:00	QQQ	ETF	113.97	114.28	113.79	114.12	1582791.0
2015-12-03 11:00:00	QQQ	ETF	114.115	114.6211	114.06	114.42	1734913.0
2015-12-03 11:30:00	QQQ	ETF	114.425	114.43	113.92	114.07	1219111.0
2015-12-03 12:00:00	QQQ	ETF	114.05	114.1087	112.975	113.12	2786971.0
2015-12-03 12:30:00	QQQ	ETF	113.13	113.34	112.91	112.94	2315573.0

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

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