PREVIEW / etf_30min / 2017-03-10

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-03-10.parquet
  size:    434 KB
  rows:    14,758

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-10 04:00:00	SPY	ETF	237.71	237.85	237.64	237.73	4950.0
2017-03-10 04:30:00	SPY	ETF	237.72	237.79	237.63	237.68	2220.0
2017-03-10 05:00:00	SPY	ETF	237.73	237.86	237.67	237.77	6765.0
2017-03-10 05:30:00	SPY	ETF	237.77	237.81	237.67	237.7	38625.0
2017-03-10 06:00:00	SPY	ETF	237.76	237.94	237.73	237.92	57556.0
2017-03-10 06:30:00	SPY	ETF	237.92	237.92	237.8	237.84	243550.0
2017-03-10 07:00:00	SPY	ETF	237.82	237.82	237.69	237.75	195496.0
2017-03-10 07:30:00	SPY	ETF	237.76	237.77	237.66	237.68	140568.0
2017-03-10 08:00:00	SPY	ETF	237.69	237.94	236.97	237.78	457741.0
2017-03-10 08:30:00	SPY	ETF	237.84	238.32	237.77	238.14	1325969.0
2017-03-10 09:00:00	SPY	ETF	238.1	238.11	237.89	237.97	768260.0
2017-03-10 09:30:00	SPY	ETF	237.97	238.02	237.42	237.94	8865784.0
2017-03-10 10:00:00	SPY	ETF	237.94	238.02	237.66	237.669	6358568.0
2017-03-10 10:30:00	SPY	ETF	237.6627	237.695	237.19	237.22	5929366.0
2017-03-10 11:00:00	SPY	ETF	237.21	237.52	236.98	237.44	5110169.0
2017-03-10 11:30:00	SPY	ETF	237.44	237.49	237.2	237.31	2744303.0
2017-03-10 12:00:00	SPY	ETF	237.32	237.45	237.22	237.39	2224472.0
2017-03-10 12:30:00	SPY	ETF	237.38	237.39	236.81	237.02	2926585.0
2017-03-10 13:00:00	SPY	ETF	237.03	237.055	236.59	236.9	3864366.0
2017-03-10 13:30:00	SPY	ETF	236.91	237.14	236.73	237.11	2990563.0
2017-03-10 14:00:00	SPY	ETF	237.11	237.34	237.005	237.31	3294226.0
2017-03-10 14:30:00	SPY	ETF	237.31	237.39	237.19	237.28	2729731.0
2017-03-10 15:00:00	SPY	ETF	237.28	237.59	237.28	237.59	3414045.0
2017-03-10 15:30:00	SPY	ETF	237.59	237.68	237.415	237.64	14540677.0
2017-03-10 16:00:00	SPY	ETF	237.64	237.69	237.38	237.49	11238541.0
2017-03-10 16:30:00	SPY	ETF	237.48	237.69	237.45	237.5	542260.0
2017-03-10 17:00:00	SPY	ETF	237.5	237.52	237.48	237.48	82390.0
2017-03-10 17:30:00	SPY	ETF	237.48	237.61	237.47	237.6	89335.0
2017-03-10 18:00:00	SPY	ETF	237.6	237.72	237.6	237.71	89117.0
2017-03-10 18:30:00	SPY	ETF	237.7	237.8	237.7	237.75	43977.0
2017-03-10 19:00:00	SPY	ETF	237.74	237.78	237.74	237.75	10609.0
2017-03-10 19:30:00	SPY	ETF	237.76	237.78	237.73	237.78	30907.0
2017-03-10 04:00:00	QQQ	ETF	131.2	131.37	131.2	131.37	1027.0
2017-03-10 05:00:00	QQQ	ETF	131.26	131.26	131.23	131.23	277.0
2017-03-10 06:00:00	QQQ	ETF	131.32	131.39	131.32	131.39	40292.0
2017-03-10 06:30:00	QQQ	ETF	131.33	131.36	131.33	131.34	23900.0
2017-03-10 07:00:00	QQQ	ETF	131.32	131.32	131.27	131.27	4877.0
2017-03-10 07:30:00	QQQ	ETF	131.3	131.32	131.22	131.26	16547.0
2017-03-10 08:00:00	QQQ	ETF	131.24	131.35	131.23	131.35	89769.0
2017-03-10 08:30:00	QQQ	ETF	131.34	131.49	131.29	131.43	166811.0
2017-03-10 09:00:00	QQQ	ETF	131.43	131.43	131.33	131.41	238937.0
2017-03-10 09:30:00	QQQ	ETF	131.42	131.58	131.2	131.54	2848084.0
2017-03-10 10:00:00	QQQ	ETF	131.55	131.6	131.42	131.4754	1186571.0
2017-03-10 10:30:00	QQQ	ETF	131.47	131.47	131.15	131.3	1491730.0
2017-03-10 11:00:00	QQQ	ETF	131.3	131.42	131.15	131.401	1096598.0
2017-03-10 11:30:00	QQQ	ETF	131.405	131.43	131.27	131.31	613300.0
2017-03-10 12:00:00	QQQ	ETF	131.32	131.33	131.2427	131.28	390682.0
2017-03-10 12:30:00	QQQ	ETF	131.289	131.289	130.9	131.04	1236237.0
2017-03-10 13:00:00	QQQ	ETF	131.05	131.07	130.82	130.98	931696.0
2017-03-10 13:30:00	QQQ	ETF	131.0	131.129	130.91	131.1058	625177.0

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

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