PREVIEW / etf_30min / 2017-03-08

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-03-08.parquet
  size:    439 KB
  rows:    14,928

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-03-08 04:00:00	SPY	ETF	236.84	236.88	236.84	236.88	315.0
2017-03-08 04:30:00	SPY	ETF	236.89	236.94	236.88	236.94	5710.0
2017-03-08 05:00:00	SPY	ETF	236.96	237.02	236.96	236.96	2671.0
2017-03-08 05:30:00	SPY	ETF	236.98	237.04	236.92	236.92	1604.0
2017-03-08 06:00:00	SPY	ETF	236.92	236.94	236.75	236.75	4356.0
2017-03-08 06:30:00	SPY	ETF	236.73	236.79	236.73	236.78	5077.0
2017-03-08 07:00:00	SPY	ETF	236.78	236.9	236.75	236.83	148963.0
2017-03-08 07:30:00	SPY	ETF	236.82	237.18	236.82	237.03	208035.0
2017-03-08 08:00:00	SPY	ETF	237.01	237.2	236.77	236.82	413890.0
2017-03-08 08:30:00	SPY	ETF	236.81	237.21	236.79	237.18	393399.0
2017-03-08 09:00:00	SPY	ETF	237.18	237.34	237.18	237.32	566013.0
2017-03-08 09:30:00	SPY	ETF	237.34	237.64	237.14	237.4	5742462.0
2017-03-08 10:00:00	SPY	ETF	237.4	237.51	237.06	237.43	4337237.0
2017-03-08 10:30:00	SPY	ETF	237.44	237.53	237.24	237.43	3131198.0
2017-03-08 11:00:00	SPY	ETF	237.43	237.54	237.25	237.37	2980078.0
2017-03-08 11:30:00	SPY	ETF	237.37	237.37	236.88	237.04	4542176.0
2017-03-08 12:00:00	SPY	ETF	237.05	237.2	236.96	237.17	2647193.0
2017-03-08 12:30:00	SPY	ETF	237.17	237.28	237.12	237.21	2707909.0
2017-03-08 13:00:00	SPY	ETF	237.205	237.5	237.16	237.37	3663343.0
2017-03-08 13:30:00	SPY	ETF	237.37	237.48	237.26	237.32	2526783.0
2017-03-08 14:00:00	SPY	ETF	237.32	237.34	236.71	236.825	6053412.0
2017-03-08 14:30:00	SPY	ETF	236.83	237.1	236.7	237.05	3422104.0
2017-03-08 15:00:00	SPY	ETF	237.04	237.14	236.88	236.885	3402946.0
2017-03-08 15:30:00	SPY	ETF	236.885	236.89	236.4	236.59	14837005.0
2017-03-08 16:00:00	SPY	ETF	236.59	237.1367	236.56	236.7	10837278.0
2017-03-08 16:30:00	SPY	ETF	236.71	236.75	236.56	236.56	658328.0
2017-03-08 17:00:00	SPY	ETF	236.64	236.69	236.55	236.56	1209035.0
2017-03-08 17:30:00	SPY	ETF	236.57	236.67	236.56	236.67	344423.0
2017-03-08 18:00:00	SPY	ETF	236.67	236.82	236.6	236.77	67610.0
2017-03-08 18:30:00	SPY	ETF	236.76	236.76	236.69	236.76	66586.0
2017-03-08 19:00:00	SPY	ETF	236.74	236.84	236.74	236.81	61794.0
2017-03-08 19:30:00	SPY	ETF	236.77	236.79	236.71	236.73	11950.0
2017-03-08 04:00:00	QQQ	ETF	130.5	130.5	130.5	130.5	105.0
2017-03-08 05:00:00	QQQ	ETF	130.56	130.56	130.56	130.56	399.0
2017-03-08 05:30:00	QQQ	ETF	130.55	130.55	130.55	130.55	19000.0
2017-03-08 06:00:00	QQQ	ETF	130.5	130.5	130.5	130.5	500.0
2017-03-08 06:30:00	QQQ	ETF	130.42	130.44	130.42	130.43	22000.0
2017-03-08 07:00:00	QQQ	ETF	130.41	130.47	130.41	130.44	12650.0
2017-03-08 07:30:00	QQQ	ETF	130.44	130.56	130.44	130.53	19379.0
2017-03-08 08:00:00	QQQ	ETF	130.53	130.56	130.34	130.39	32601.0
2017-03-08 08:30:00	QQQ	ETF	130.34	130.54	130.34	130.51	54817.0
2017-03-08 09:00:00	QQQ	ETF	130.54	130.6	130.51	130.55	62267.0
2017-03-08 09:30:00	QQQ	ETF	130.56	130.955	130.46	130.94	1780562.0
2017-03-08 10:00:00	QQQ	ETF	130.94	131.06	130.76	131.06	1385316.0
2017-03-08 10:30:00	QQQ	ETF	131.05	131.07	130.89	131.02	844508.0
2017-03-08 11:00:00	QQQ	ETF	131.02	131.15	130.9934	131.02	1016436.0
2017-03-08 11:30:00	QQQ	ETF	131.02	131.02	130.62	130.7499	847653.0
2017-03-08 12:00:00	QQQ	ETF	130.75	130.81	130.6899	130.795	619760.0
2017-03-08 12:30:00	QQQ	ETF	130.8	130.915	130.79	130.9	535859.0
2017-03-08 13:00:00	QQQ	ETF	130.89	131.08	130.87	131.005	670765.0

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

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