PREVIEW / etf_30min / 2017-08-11

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-08-11.parquet
  size:    437 KB
  rows:    15,032

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-08-11 04:00:00	SPY	ETF	243.75	243.75	243.27	243.27	15801.0
2017-08-11 04:30:00	SPY	ETF	243.22	243.45	243.22	243.45	28122.0
2017-08-11 05:00:00	SPY	ETF	243.45	243.45	243.24	243.37	11059.0
2017-08-11 05:30:00	SPY	ETF	243.42	243.57	243.42	243.47	7601.0
2017-08-11 06:00:00	SPY	ETF	243.55	243.6	243.49	243.55	7460.0
2017-08-11 06:30:00	SPY	ETF	243.58	243.63	243.39	243.4	51540.0
2017-08-11 07:00:00	SPY	ETF	243.43	243.59	243.34	243.5	92103.0
2017-08-11 07:30:00	SPY	ETF	243.5	243.51	243.16	243.44	190457.0
2017-08-11 08:00:00	SPY	ETF	243.34	243.85	243.34	243.76	349436.0
2017-08-11 08:30:00	SPY	ETF	243.76	244.36	243.68	244.19	1790747.0
2017-08-11 09:00:00	SPY	ETF	244.15	244.6	243.96	244.02	1343841.0
2017-08-11 09:30:00	SPY	ETF	244.02	244.39	243.75	244.17	10625958.0
2017-08-11 10:00:00	SPY	ETF	244.17	244.69	244.045	244.435	5921429.0
2017-08-11 10:30:00	SPY	ETF	244.44	244.8	244.27	244.61	4938764.0
2017-08-11 11:00:00	SPY	ETF	244.61	244.62	244.03	244.08	3698780.0
2017-08-11 11:30:00	SPY	ETF	244.07	244.52	244.03	244.25	2862946.0
2017-08-11 12:00:00	SPY	ETF	244.25	244.51	244.18	244.32	2271882.0
2017-08-11 12:30:00	SPY	ETF	244.325	244.52	244.25	244.335	1688465.0
2017-08-11 13:00:00	SPY	ETF	244.335	244.55	244.32	244.36	2143749.0
2017-08-11 13:30:00	SPY	ETF	244.37	244.49	244.25	244.42	1811477.0
2017-08-11 14:00:00	SPY	ETF	244.42	244.7	244.39	244.4599	2505045.0
2017-08-11 14:30:00	SPY	ETF	244.455	244.49	243.87	243.9363	4278896.0
2017-08-11 15:00:00	SPY	ETF	243.94	244.17	243.78	244.035	6308348.0
2017-08-11 15:30:00	SPY	ETF	244.035	244.4	243.9	244.11	11322902.0
2017-08-11 16:00:00	SPY	ETF	244.1	244.6101	244.03	244.2	7923199.0
2017-08-11 16:30:00	SPY	ETF	244.21	244.32	244.0936	244.19	1778691.0
2017-08-11 17:00:00	SPY	ETF	244.19	244.26	244.19	244.26	60765.0
2017-08-11 17:30:00	SPY	ETF	244.27	244.33	244.24	244.28	27102.0
2017-08-11 18:00:00	SPY	ETF	244.28	244.28	244.23	244.26	23001.0
2017-08-11 18:30:00	SPY	ETF	244.26	244.26	244.09	244.14	79009.0
2017-08-11 19:00:00	SPY	ETF	244.15	244.16	244.15	244.16	2996.0
2017-08-11 19:30:00	SPY	ETF	244.14	244.2	244.14	244.16	19254.0
2017-08-11 04:00:00	QQQ	ETF	140.8	140.86	140.65	140.65	6182.0
2017-08-11 04:30:00	QQQ	ETF	140.45	140.56	140.35	140.56	24589.0
2017-08-11 05:00:00	QQQ	ETF	140.51	140.57	140.5	140.52	2100.0
2017-08-11 05:30:00	QQQ	ETF	140.63	140.75	140.63	140.75	27699.0
2017-08-11 06:00:00	QQQ	ETF	140.7	140.8	140.7	140.76	4422.0
2017-08-11 06:30:00	QQQ	ETF	140.73	140.78	140.62	140.62	10749.0
2017-08-11 07:00:00	QQQ	ETF	140.63	140.78	140.56	140.7	28340.0
2017-08-11 07:30:00	QQQ	ETF	140.7	140.72	140.47	140.66	21165.0
2017-08-11 08:00:00	QQQ	ETF	140.63	140.85	140.54	140.82	169052.0
2017-08-11 08:30:00	QQQ	ETF	140.8	141.21	140.75	141.17	602958.0
2017-08-11 09:00:00	QQQ	ETF	141.14	141.4	141.12	141.22	500677.0
2017-08-11 09:30:00	QQQ	ETF	141.24	141.61	140.9	141.57	7922573.0
2017-08-11 10:00:00	QQQ	ETF	141.57	142.06	141.44	141.81	4852386.0
2017-08-11 10:30:00	QQQ	ETF	141.81	142.09	141.64	141.9	2663496.0
2017-08-11 11:00:00	QQQ	ETF	141.89	141.94	141.46	141.51	2085659.0
2017-08-11 11:30:00	QQQ	ETF	141.5015	141.955	141.5001	141.76	1595412.0
2017-08-11 12:00:00	QQQ	ETF	141.755	142.16	141.725	141.99	1405354.0
2017-08-11 12:30:00	QQQ	ETF	141.99	142.2	141.91	142.05	842114.0

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

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