PREVIEW / etf_30min / 2017-02-03

all etf 30-min files

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

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-03 04:00:00	SPY	ETF	227.87	227.94	227.86	227.93	3140.0
2017-02-03 04:30:00	SPY	ETF	227.93	227.95	227.92	227.95	1400.0
2017-02-03 05:00:00	SPY	ETF	227.97	227.97	227.86	227.86	400.0
2017-02-03 05:30:00	SPY	ETF	227.89	227.9	227.84	227.84	1400.0
2017-02-03 06:00:00	SPY	ETF	227.84	228.13	227.84	228.08	5627.0
2017-02-03 06:30:00	SPY	ETF	228.09	228.1	228.02	228.02	21605.0
2017-02-03 07:00:00	SPY	ETF	228.01	228.1	228.01	228.01	37629.0
2017-02-03 07:30:00	SPY	ETF	228.0	228.04	227.96	228.01	54801.0
2017-02-03 08:00:00	SPY	ETF	228.05	228.12	227.95	228.04	199130.0
2017-02-03 08:30:00	SPY	ETF	227.95	228.75	227.95	228.68	1802380.0
2017-02-03 09:00:00	SPY	ETF	228.68	228.83	228.57	228.8	628270.0
2017-02-03 09:30:00	SPY	ETF	228.82	228.86	228.46	228.7	8731652.0
2017-02-03 10:00:00	SPY	ETF	228.7	229.3	228.67	229.105	7655724.0
2017-02-03 10:30:00	SPY	ETF	229.1	229.4	228.99	229.25	5807227.0
2017-02-03 11:00:00	SPY	ETF	229.255	229.52	229.12	229.27	4896044.0
2017-02-03 11:30:00	SPY	ETF	229.26	229.32	229.08	229.24	3703086.0
2017-02-03 12:00:00	SPY	ETF	229.235	229.42	229.23	229.31	2950995.0
2017-02-03 12:30:00	SPY	ETF	229.31	229.4	229.28	229.356	2075741.0
2017-02-03 13:00:00	SPY	ETF	229.35	229.43	229.22	229.32	1509128.0
2017-02-03 13:30:00	SPY	ETF	229.3201	229.36	229.18	229.21	2641170.0
2017-02-03 14:00:00	SPY	ETF	229.21	229.38	229.2	229.27	2366002.0
2017-02-03 14:30:00	SPY	ETF	229.26	229.44	229.25	229.36	2176312.0
2017-02-03 15:00:00	SPY	ETF	229.36	229.51	229.32	229.355	4394858.0
2017-02-03 15:30:00	SPY	ETF	229.359	229.55	229.25	229.37	14531894.0
2017-02-03 16:00:00	SPY	ETF	229.36	229.4437	227.7907	229.32	11200723.0
2017-02-03 16:30:00	SPY	ETF	229.32	229.38	227.7907	229.33	1340981.0
2017-02-03 17:00:00	SPY	ETF	229.31	229.32	229.25	229.29	37028.0
2017-02-03 17:30:00	SPY	ETF	229.3	229.43	229.3	229.43	53814.0
2017-02-03 18:00:00	SPY	ETF	229.34	229.39	229.34	229.36	12002.0
2017-02-03 18:30:00	SPY	ETF	229.37	229.4	229.37	229.4	1000.0
2017-02-03 19:00:00	SPY	ETF	229.4	229.41	229.38	229.41	7500.0
2017-02-03 19:30:00	SPY	ETF	229.39	229.448	229.38	229.41	2054132.0
2017-02-03 05:30:00	QQQ	ETF	125.12	125.13	125.12	125.13	800.0
2017-02-03 06:00:00	QQQ	ETF	125.13	125.28	125.13	125.28	15247.0
2017-02-03 06:30:00	QQQ	ETF	125.23	125.26	125.23	125.26	9999.0
2017-02-03 07:00:00	QQQ	ETF	125.21	125.21	125.2	125.2	1800.0
2017-02-03 07:30:00	QQQ	ETF	125.14	125.17	125.14	125.17	3050.0
2017-02-03 08:00:00	QQQ	ETF	125.16	125.19	125.08	125.11	34333.0
2017-02-03 08:30:00	QQQ	ETF	125.25	125.52	125.16	125.47	224021.0
2017-02-03 09:00:00	QQQ	ETF	125.46	125.49	125.37	125.47	253526.0
2017-02-03 09:30:00	QQQ	ETF	125.47	125.65	125.4	125.53	1906109.0
2017-02-03 10:00:00	QQQ	ETF	125.52	125.81	125.44	125.665	1683851.0
2017-02-03 10:30:00	QQQ	ETF	125.66	125.71	125.5361	125.59	1027031.0
2017-02-03 11:00:00	QQQ	ETF	125.59	125.73	125.42	125.5	1100684.0
2017-02-03 11:30:00	QQQ	ETF	125.49	125.53	125.33	125.4401	635590.0
2017-02-03 12:00:00	QQQ	ETF	125.45	125.58	125.44	125.535	577356.0
2017-02-03 12:30:00	QQQ	ETF	125.5373	125.59	125.52	125.539	561304.0
2017-02-03 13:00:00	QQQ	ETF	125.54	125.59	125.47	125.58	455377.0
2017-02-03 13:30:00	QQQ	ETF	125.57	125.6	125.45	125.51	623969.0
2017-02-03 14:00:00	QQQ	ETF	125.51	125.6	125.5	125.56	401741.0

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

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