PREVIEW / etf_30min / 2017-07-13

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-07-13.parquet
  size:    417 KB
  rows:    14,674

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-07-13 04:00:00	SPY	ETF	244.18	244.18	244.18	244.18	100.0
2017-07-13 04:30:00	SPY	ETF	244.36	244.36	244.32	244.33	501.0
2017-07-13 05:00:00	SPY	ETF	244.37	244.48	244.32	244.34	4640.0
2017-07-13 05:30:00	SPY	ETF	244.33	244.33	244.27	244.33	9205.0
2017-07-13 06:00:00	SPY	ETF	244.3	244.33	244.24	244.28	17412.0
2017-07-13 06:30:00	SPY	ETF	244.25	244.27	244.2	244.2	43897.0
2017-07-13 07:00:00	SPY	ETF	244.2	244.21	244.04	244.04	31293.0
2017-07-13 07:30:00	SPY	ETF	244.03	244.07	243.95	244.0	76250.0
2017-07-13 08:00:00	SPY	ETF	244.02	244.16	244.0	244.13	113456.0
2017-07-13 08:30:00	SPY	ETF	244.14	244.18	244.01	244.1	155430.0
2017-07-13 09:00:00	SPY	ETF	244.1	244.14	244.0	244.02	257128.0
2017-07-13 09:30:00	SPY	ETF	244.02	244.33	243.9	244.27	4013007.0
2017-07-13 10:00:00	SPY	ETF	244.27	244.34	243.8	243.87	3528437.0
2017-07-13 10:30:00	SPY	ETF	243.85	244.08	243.76	244.03	2264861.0
2017-07-13 11:00:00	SPY	ETF	244.02	244.315	244.01	244.22	1911225.0
2017-07-13 11:30:00	SPY	ETF	244.22	244.44	244.1399	244.36	2343640.0
2017-07-13 12:00:00	SPY	ETF	244.36	244.49	244.29	244.42	1228938.0
2017-07-13 12:30:00	SPY	ETF	244.43	244.48	244.33	244.45	1829361.0
2017-07-13 13:00:00	SPY	ETF	244.44	244.49	244.35	244.4	1250243.0
2017-07-13 13:30:00	SPY	ETF	244.39	244.44	244.255	244.36	1643913.0
2017-07-13 14:00:00	SPY	ETF	244.36	244.39	244.15	244.3	2783425.0
2017-07-13 14:30:00	SPY	ETF	244.29	244.46	244.26	244.425	1276789.0
2017-07-13 15:00:00	SPY	ETF	244.42	244.47	244.3	244.4154	1861242.0
2017-07-13 15:30:00	SPY	ETF	244.415	244.55	244.35	244.41	6583227.0
2017-07-13 16:00:00	SPY	ETF	244.4	244.49	244.31	244.4	3716791.0
2017-07-13 16:30:00	SPY	ETF	244.4	244.5	244.39	244.5	1438593.0
2017-07-13 17:00:00	SPY	ETF	244.49	244.49	244.44	244.44	12234.0
2017-07-13 17:30:00	SPY	ETF	244.46	244.47	244.39	244.45	50428.0
2017-07-13 18:00:00	SPY	ETF	244.44	244.44	244.34	244.39	37484.0
2017-07-13 18:30:00	SPY	ETF	244.4	244.42	244.4	244.42	8507.0
2017-07-13 19:00:00	SPY	ETF	244.42	244.42	244.4	244.4	4457.0
2017-07-13 19:30:00	SPY	ETF	244.4	244.46	244.39	244.43	25327.0
2017-07-13 04:00:00	QQQ	ETF	141.12	141.15	141.12	141.15	600.0
2017-07-13 04:30:00	QQQ	ETF	141.32	141.32	141.28	141.28	2838.0
2017-07-13 05:00:00	QQQ	ETF	141.32	141.42	141.32	141.32	2998.0
2017-07-13 05:30:00	QQQ	ETF	141.31	141.35	141.28	141.31	2500.0
2017-07-13 06:00:00	QQQ	ETF	141.29	141.31	141.29	141.31	1200.0
2017-07-13 06:30:00	QQQ	ETF	141.24	141.24	141.18	141.19	18030.0
2017-07-13 07:00:00	QQQ	ETF	141.14	141.19	141.05	141.05	73312.0
2017-07-13 07:30:00	QQQ	ETF	141.05	141.07	141.0	141.02	43945.0
2017-07-13 08:00:00	QQQ	ETF	141.13	141.13	141.01	141.1	26985.0
2017-07-13 08:30:00	QQQ	ETF	141.11	141.15	140.92	140.97	43348.0
2017-07-13 09:00:00	QQQ	ETF	140.96	141.34	140.82	140.82	156084.0
2017-07-13 09:30:00	QQQ	ETF	140.81	141.35	140.675	141.28	3286570.0
2017-07-13 10:00:00	QQQ	ETF	141.28	141.35	140.68	140.78	2911745.0
2017-07-13 10:30:00	QQQ	ETF	140.78	140.95	140.6	140.9	2553879.0
2017-07-13 11:00:00	QQQ	ETF	140.905	141.08	140.86	140.87	1426872.0
2017-07-13 11:30:00	QQQ	ETF	140.88	141.12	140.79	141.1	1031879.0
2017-07-13 12:00:00	QQQ	ETF	141.09	141.28	141.03	141.22	1004505.0
2017-07-13 12:30:00	QQQ	ETF	141.2263	141.29	141.16	141.27	828782.0

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

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