PREVIEW / etf_30min / 2016-08-18

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-08-18.parquet
  size:    388 KB
  rows:    13,135

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
2016-08-18 04:00:00	SPY	ETF	218.45	218.5	218.38	218.5	1043.0
2016-08-18 05:00:00	SPY	ETF	218.46	218.46	218.46	218.46	600.0
2016-08-18 05:30:00	SPY	ETF	218.41	218.43	218.35	218.38	2701.0
2016-08-18 06:00:00	SPY	ETF	218.41	218.41	218.39	218.39	224.0
2016-08-18 06:30:00	SPY	ETF	218.43	218.43	218.36	218.4	15751.0
2016-08-18 07:00:00	SPY	ETF	218.34	218.39	218.22	218.29	65672.0
2016-08-18 07:30:00	SPY	ETF	218.29	218.29	218.1	218.13	58096.0
2016-08-18 08:00:00	SPY	ETF	218.15	218.679	218.1	218.2	196343.0
2016-08-18 08:30:00	SPY	ETF	218.2	218.26	218.2	218.23	74949.0
2016-08-18 09:00:00	SPY	ETF	218.2	218.36	218.2	218.33	121685.0
2016-08-18 09:30:00	SPY	ETF	218.34	218.6	218.21	218.46	6336086.0
2016-08-18 10:00:00	SPY	ETF	218.46	218.62	218.38	218.51	3716062.0
2016-08-18 10:30:00	SPY	ETF	218.52	218.86	218.511	218.84	4943073.0
2016-08-18 11:00:00	SPY	ETF	218.84	218.84	218.65	218.79	2649174.0
2016-08-18 11:30:00	SPY	ETF	218.79	218.825	218.57	218.6	3733070.0
2016-08-18 12:00:00	SPY	ETF	218.59	218.59	218.31	218.328	2813489.0
2016-08-18 12:30:00	SPY	ETF	218.32	218.47	218.24	218.39	2437544.0
2016-08-18 13:00:00	SPY	ETF	218.4	218.57	218.39	218.49	2007873.0
2016-08-18 13:30:00	SPY	ETF	218.485	218.7	218.48	218.6	2203310.0
2016-08-18 14:00:00	SPY	ETF	218.6	218.67	218.54	218.62	2393957.0
2016-08-18 14:30:00	SPY	ETF	218.62	218.65	218.49	218.605	3460197.0
2016-08-18 15:00:00	SPY	ETF	218.6	218.83	218.59	218.78	3741473.0
2016-08-18 15:30:00	SPY	ETF	218.78	218.9	218.66	218.87	6887712.0
2016-08-18 16:00:00	SPY	ETF	218.87	218.9	218.7467	218.77	2782183.0
2016-08-18 16:30:00	SPY	ETF	218.78	218.9	218.76	218.78	121297.0
2016-08-18 17:00:00	SPY	ETF	218.77	218.8	218.74	218.78	135658.0
2016-08-18 17:30:00	SPY	ETF	218.78	218.84	218.78	218.82	207149.0
2016-08-18 18:00:00	SPY	ETF	218.82	218.86	218.79	218.86	103110.0
2016-08-18 18:30:00	SPY	ETF	218.86	218.86	218.81	218.84	49539.0
2016-08-18 19:00:00	SPY	ETF	218.84	218.84	218.81	218.81	7862.0
2016-08-18 19:30:00	SPY	ETF	218.84	218.86	218.82	218.86	27776.0
2016-08-18 04:00:00	QQQ	ETF	117.2	117.25	117.2	117.25	1198.0
2016-08-18 05:00:00	QQQ	ETF	117.15	117.15	117.15	117.15	798.0
2016-08-18 05:30:00	QQQ	ETF	117.15	117.15	117.13	117.13	1202.0
2016-08-18 06:00:00	QQQ	ETF	117.11	117.11	117.11	117.11	1500.0
2016-08-18 06:30:00	QQQ	ETF	117.16	117.16	117.13	117.13	859.0
2016-08-18 07:00:00	QQQ	ETF	117.14	117.14	117.07	117.07	2500.0
2016-08-18 07:30:00	QQQ	ETF	117.07	117.08	116.97	116.97	6040.0
2016-08-18 08:00:00	QQQ	ETF	117.0	117.04	116.96	117.04	23636.0
2016-08-18 08:30:00	QQQ	ETF	117.04	117.1	117.04	117.09	18119.0
2016-08-18 09:00:00	QQQ	ETF	117.07	117.17	117.07	117.17	21911.0
2016-08-18 09:30:00	QQQ	ETF	117.15	117.34	117.0	117.24	1619943.0
2016-08-18 10:00:00	QQQ	ETF	117.24	117.41	117.19	117.3566	1030531.0
2016-08-18 10:30:00	QQQ	ETF	117.3571	117.46	117.32	117.43	1124073.0
2016-08-18 11:00:00	QQQ	ETF	117.44	117.45	117.2884	117.38	560907.0
2016-08-18 11:30:00	QQQ	ETF	117.3801	117.4	117.29	117.32	351468.0
2016-08-18 12:00:00	QQQ	ETF	117.32	117.32	117.1	117.1	547093.0
2016-08-18 12:30:00	QQQ	ETF	117.1001	117.15	116.945	117.1	727624.0
2016-08-18 13:00:00	QQQ	ETF	117.11	117.23	117.11	117.207	193837.0
2016-08-18 13:30:00	QQQ	ETF	117.21	117.35	117.205	117.285	262522.0

> showing 50 of 13,135 rows — these rows as CSV

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