PREVIEW / etf_30min / 2017-04-03

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-04-03.parquet
  size:    436 KB
  rows:    14,857

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
2017-04-03 04:00:00	SPY	ETF	236.13	236.13	235.75	235.75	1991.0
2017-04-03 04:30:00	SPY	ETF	235.82	235.94	235.82	235.94	3400.0
2017-04-03 05:00:00	SPY	ETF	235.91	235.91	235.91	235.91	700.0
2017-04-03 05:30:00	SPY	ETF	235.92	236.0	235.92	236.0	1025.0
2017-04-03 06:00:00	SPY	ETF	236.0	236.0	235.88	235.88	555.0
2017-04-03 06:30:00	SPY	ETF	235.84	235.84	235.8	235.81	11250.0
2017-04-03 07:00:00	SPY	ETF	235.81	235.83	235.75	235.76	100634.0
2017-04-03 07:30:00	SPY	ETF	235.78	235.86	235.75	235.75	189104.0
2017-04-03 08:00:00	SPY	ETF	235.82	235.87	235.68	235.85	283556.0
2017-04-03 08:30:00	SPY	ETF	235.85	235.95	235.78	235.86	203918.0
2017-04-03 09:00:00	SPY	ETF	235.87	235.9	235.74	235.8	735537.0
2017-04-03 09:30:00	SPY	ETF	235.8	236.03	235.69	235.77	8832484.0
2017-04-03 10:00:00	SPY	ETF	235.76	235.9	235.16	235.57	7491035.0
2017-04-03 10:30:00	SPY	ETF	235.57	235.67	234.64	234.67	7540923.0
2017-04-03 11:00:00	SPY	ETF	234.675	234.84	234.24	234.6	8628601.0
2017-04-03 11:30:00	SPY	ETF	234.6	234.68	234.16	234.32	4116691.0
2017-04-03 12:00:00	SPY	ETF	234.32	234.73	233.91	234.695	5181025.0
2017-04-03 12:30:00	SPY	ETF	234.69	234.83	234.58	234.82	3333931.0
2017-04-03 13:00:00	SPY	ETF	234.82	234.97	234.66	234.755	2297173.0
2017-04-03 13:30:00	SPY	ETF	234.76	234.79	234.46	234.75	2078092.0
2017-04-03 14:00:00	SPY	ETF	234.76	235.7412	234.49	234.8438	3161923.0
2017-04-03 14:30:00	SPY	ETF	234.845	235.27	234.79	235.12	4067912.0
2017-04-03 15:00:00	SPY	ETF	235.13	235.52	235.06	235.3734	4011260.0
2017-04-03 15:30:00	SPY	ETF	235.375	235.47	235.18	235.37	9205572.0
2017-04-03 16:00:00	SPY	ETF	235.37	235.6	235.32	235.44	9592435.0
2017-04-03 16:30:00	SPY	ETF	235.45	235.45	235.3	235.33	327520.0
2017-04-03 17:00:00	SPY	ETF	235.33	235.34	235.26	235.26	97029.0
2017-04-03 17:30:00	SPY	ETF	235.28	235.32	235.28	235.29	13757.0
2017-04-03 18:00:00	SPY	ETF	235.3	235.38	235.29	235.33	69933.0
2017-04-03 18:30:00	SPY	ETF	235.35	235.37	235.28	235.36	16622.0
2017-04-03 19:00:00	SPY	ETF	235.33	235.39	235.32	235.38	3463.0
2017-04-03 19:30:00	SPY	ETF	235.37	235.38	235.34	235.34	18302.0
2017-04-03 04:00:00	QQQ	ETF	132.49	132.49	132.49	132.49	1300.0
2017-04-03 05:30:00	QQQ	ETF	132.57	132.6	132.57	132.6	25000.0
2017-04-03 06:00:00	QQQ	ETF	132.58	132.58	132.58	132.58	500.0
2017-04-03 07:00:00	QQQ	ETF	132.5	132.5	132.49	132.49	1082.0
2017-04-03 07:30:00	QQQ	ETF	132.49	132.52	132.46	132.46	9039.0
2017-04-03 08:00:00	QQQ	ETF	132.48	132.51	132.45	132.51	14412.0
2017-04-03 08:30:00	QQQ	ETF	132.53	132.57	132.52	132.53	15076.0
2017-04-03 09:00:00	QQQ	ETF	132.53	132.55	132.38	132.47	229535.0
2017-04-03 09:30:00	QQQ	ETF	132.48	132.81	132.43	132.6	2467893.0
2017-04-03 10:00:00	QQQ	ETF	132.6	132.731	132.3	132.56	2113508.0
2017-04-03 10:30:00	QQQ	ETF	132.56	132.58	132.06	132.07	1782520.0
2017-04-03 11:00:00	QQQ	ETF	132.08	132.16	131.76	132.07	2401992.0
2017-04-03 11:30:00	QQQ	ETF	132.07	132.14	131.76	131.85	1618317.0
2017-04-03 12:00:00	QQQ	ETF	131.85	131.985	131.56	131.955	1703525.0
2017-04-03 12:30:00	QQQ	ETF	131.95	132.1	131.92	132.095	1168248.0
2017-04-03 13:00:00	QQQ	ETF	132.1	132.18	131.98	132.05	1093560.0
2017-04-03 13:30:00	QQQ	ETF	132.055	132.065	131.85	132.0347	731932.0
2017-04-03 14:00:00	QQQ	ETF	132.04	132.165	131.925	132.14	641833.0

> showing 50 of 14,857 rows — these rows as CSV

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