PREVIEW / etf_30min / 2017-02-13

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-02-13.parquet
  size:    439 KB
  rows:    15,173

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-02-13 04:00:00	SPY	ETF	231.68	231.73	231.67	231.73	700.0
2017-02-13 04:30:00	SPY	ETF	231.72	231.74	231.72	231.74	360.0
2017-02-13 05:00:00	SPY	ETF	231.7	231.7	231.67	231.67	860.0
2017-02-13 05:30:00	SPY	ETF	231.74	231.77	231.68	231.68	2283.0
2017-02-13 06:00:00	SPY	ETF	231.72	231.75	231.72	231.75	2745.0
2017-02-13 06:30:00	SPY	ETF	231.76	231.79	231.74	231.78	3559.0
2017-02-13 07:00:00	SPY	ETF	231.78	231.89	231.78	231.89	23184.0
2017-02-13 07:30:00	SPY	ETF	231.9	231.95	231.8	231.89	61353.0
2017-02-13 08:00:00	SPY	ETF	231.85	232.06	231.78	232.01	231172.0
2017-02-13 08:30:00	SPY	ETF	232.04	232.04	231.9	232.01	155078.0
2017-02-13 09:00:00	SPY	ETF	232.0	232.16	231.94	232.08	513849.0
2017-02-13 09:30:00	SPY	ETF	232.08	232.45	232.05	232.291	6880207.0
2017-02-13 10:00:00	SPY	ETF	232.2905	232.5	232.28	232.45	3850891.0
2017-02-13 10:30:00	SPY	ETF	232.45	232.51	232.3	232.49	3080656.0
2017-02-13 11:00:00	SPY	ETF	232.49	232.64	232.33	232.57	2529717.0
2017-02-13 11:30:00	SPY	ETF	232.57	232.595	232.38	232.4037	2424238.0
2017-02-13 12:00:00	SPY	ETF	232.4	232.55	232.39	232.53	1603085.0
2017-02-13 12:30:00	SPY	ETF	232.54	232.75	232.53	232.73	2511774.0
2017-02-13 13:00:00	SPY	ETF	232.726	233.0	232.65	232.979	3101553.0
2017-02-13 13:30:00	SPY	ETF	232.98	233.07	232.88	232.91	2682808.0
2017-02-13 14:00:00	SPY	ETF	232.9151	232.99	232.85	232.8821	2852706.0
2017-02-13 14:30:00	SPY	ETF	232.89	232.89	232.72	232.74	2985754.0
2017-02-13 15:00:00	SPY	ETF	232.73	232.845	232.695	232.76	3530354.0
2017-02-13 15:30:00	SPY	ETF	232.76	232.84	232.63	232.73	8049115.0
2017-02-13 16:00:00	SPY	ETF	232.74	232.85	232.5995	232.81	5619325.0
2017-02-13 16:30:00	SPY	ETF	232.8	232.88	232.8	232.86	739065.0
2017-02-13 17:00:00	SPY	ETF	232.85	232.86	232.77	232.83	170016.0
2017-02-13 17:30:00	SPY	ETF	232.83	232.87	232.82	232.83	42660.0
2017-02-13 18:00:00	SPY	ETF	232.83	232.91	232.77	232.9	45793.0
2017-02-13 18:30:00	SPY	ETF	232.87	232.87	232.83	232.84	3571.0
2017-02-13 19:00:00	SPY	ETF	232.87	232.88	232.81	232.82	24840.0
2017-02-13 19:30:00	SPY	ETF	232.81	232.86	232.81	232.84	40855.0
2017-02-13 04:00:00	QQQ	ETF	127.51	127.51	127.51	127.51	100.0
2017-02-13 05:30:00	QQQ	ETF	127.51	127.51	127.44	127.44	200.0
2017-02-13 06:00:00	QQQ	ETF	127.49	127.5	127.49	127.5	15118.0
2017-02-13 06:30:00	QQQ	ETF	127.49	127.55	127.47	127.47	41999.0
2017-02-13 07:00:00	QQQ	ETF	127.56	127.58	127.53	127.58	12966.0
2017-02-13 07:30:00	QQQ	ETF	127.57	127.62	127.56	127.61	2423.0
2017-02-13 08:00:00	QQQ	ETF	127.58	127.65	127.58	127.65	32762.0
2017-02-13 08:30:00	QQQ	ETF	127.65	127.65	127.61	127.63	5849.0
2017-02-13 09:00:00	QQQ	ETF	127.63	127.77	127.63	127.75	173705.0
2017-02-13 09:30:00	QQQ	ETF	127.76	127.91	127.7199	127.865	2750524.0
2017-02-13 10:00:00	QQQ	ETF	127.8645	128.0	127.85	128.0	1062940.0
2017-02-13 10:30:00	QQQ	ETF	127.995	128.0	127.83	127.97	1356661.0
2017-02-13 11:00:00	QQQ	ETF	127.97	128.05	127.85	128.015	1411853.0
2017-02-13 11:30:00	QQQ	ETF	128.01	128.0484	127.96	127.963	757017.0
2017-02-13 12:00:00	QQQ	ETF	127.965	128.05	127.95	128.035	634260.0
2017-02-13 12:30:00	QQQ	ETF	128.03	128.14	128.01	128.1038	674545.0
2017-02-13 13:00:00	QQQ	ETF	128.1	128.19	128.05	128.175	840470.0
2017-02-13 13:30:00	QQQ	ETF	128.19	128.21	128.11	128.17	812316.0

> showing 50 of 15,173 rows — these rows as CSV

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