PREVIEW / etf_30min / 2018-05-29

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-05-29.parquet
  size:    479 KB
  rows:    16,576

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
2018-05-29 04:00:00	SPY	ETF	270.9	270.9	270.0	270.0	25106.0
2018-05-29 04:30:00	SPY	ETF	269.94	270.02	269.33	269.92	74636.0
2018-05-29 05:00:00	SPY	ETF	269.92	270.12	269.74	270.11	52937.0
2018-05-29 05:30:00	SPY	ETF	269.94	270.29	269.79	270.29	27902.0
2018-05-29 06:00:00	SPY	ETF	270.35	270.51	270.23	270.35	155744.0
2018-05-29 06:30:00	SPY	ETF	270.24	270.36	269.8	269.87	68224.0
2018-05-29 07:00:00	SPY	ETF	269.87	270.04	269.57	270.02	227299.0
2018-05-29 07:30:00	SPY	ETF	270.0	270.44	270.0	270.24	290645.0
2018-05-29 08:00:00	SPY	ETF	269.6201	271.75	269.605	270.61	500444.0
2018-05-29 08:30:00	SPY	ETF	270.62	270.74	270.41	270.73	472066.0
2018-05-29 09:00:00	SPY	ETF	270.69	270.77	270.05	270.28	511512.0
2018-05-29 09:30:00	SPY	ETF	270.31	271.08	269.92	270.93	8996105.0
2018-05-29 10:00:00	SPY	ETF	270.93	271.17	270.59	270.87	5888871.0
2018-05-29 10:30:00	SPY	ETF	270.885	270.885	270.32	270.34	4300354.0
2018-05-29 11:00:00	SPY	ETF	270.36	270.49	269.86	270.17	5655767.0
2018-05-29 11:30:00	SPY	ETF	270.17	270.2	268.85	268.9163	7187538.0
2018-05-29 12:00:00	SPY	ETF	268.92	268.93	267.89	268.51	8112822.0
2018-05-29 12:30:00	SPY	ETF	268.51	269.39	268.48	269.29	5972486.0
2018-05-29 13:00:00	SPY	ETF	269.28	269.3	268.48	268.7458	5043529.0
2018-05-29 13:30:00	SPY	ETF	268.75	268.98	268.275	268.61	4076823.0
2018-05-29 14:00:00	SPY	ETF	268.6	268.62	267.91	268.58	4949937.0
2018-05-29 14:30:00	SPY	ETF	268.58	268.84	267.77	267.83	6748151.0
2018-05-29 15:00:00	SPY	ETF	267.84	268.25	267.76	268.13	8992336.0
2018-05-29 15:30:00	SPY	ETF	268.125	269.38	267.96	269.1	19377786.0
2018-05-29 16:00:00	SPY	ETF	269.07	269.54	269.02	269.41	13276762.0
2018-05-29 16:30:00	SPY	ETF	269.42	269.56	268.7832	269.5	864444.0
2018-05-29 17:00:00	SPY	ETF	269.51	269.6	269.02	269.51	607775.0
2018-05-29 17:30:00	SPY	ETF	269.5	269.55	269.48	269.55	27887.0
2018-05-29 18:00:00	SPY	ETF	269.52	269.58	269.42	269.54	68292.0
2018-05-29 18:30:00	SPY	ETF	269.56	269.58	269.28	269.28	14268.0
2018-05-29 19:00:00	SPY	ETF	269.29	269.42	269.12	269.12	61420.0
2018-05-29 19:30:00	SPY	ETF	269.12	269.26	269.02	269.1	44349.0
2018-05-29 04:00:00	QQQ	ETF	169.27	169.28	168.5	168.5	14519.0
2018-05-29 04:30:00	QQQ	ETF	168.16	168.47	168.07	168.41	19100.0
2018-05-29 05:00:00	QQQ	ETF	168.4	168.6	168.4	168.6	8065.0
2018-05-29 05:30:00	QQQ	ETF	168.46	168.79	168.46	168.79	9400.0
2018-05-29 06:00:00	QQQ	ETF	168.81	169.07	168.81	168.93	30737.0
2018-05-29 06:30:00	QQQ	ETF	168.82	168.85	168.55	168.67	12980.0
2018-05-29 07:00:00	QQQ	ETF	168.65	168.68	168.35	168.62	79915.0
2018-05-29 07:30:00	QQQ	ETF	168.63	168.83	168.63	168.69	33361.0
2018-05-29 08:00:00	QQQ	ETF	168.68	169.04	168.38	169.03	160460.0
2018-05-29 08:30:00	QQQ	ETF	169.0	169.22	168.83	169.22	97618.0
2018-05-29 09:00:00	QQQ	ETF	169.11	169.17	168.69	168.89	175014.0
2018-05-29 09:30:00	QQQ	ETF	168.9	169.75	168.57	169.65	5429728.0
2018-05-29 10:00:00	QQQ	ETF	169.65	169.92	169.3116	169.53	2343467.0
2018-05-29 10:30:00	QQQ	ETF	169.53	169.82	169.12	169.47	2153367.0
2018-05-29 11:00:00	QQQ	ETF	169.46	169.55	169.15	169.31	2393144.0
2018-05-29 11:30:00	QQQ	ETF	169.33	169.4	168.391	168.53	2385046.0
2018-05-29 12:00:00	QQQ	ETF	168.53	168.55	167.96	168.45	2282072.0
2018-05-29 12:30:00	QQQ	ETF	168.45	169.04	168.42	169.0	1716850.0

> showing 50 of 16,576 rows — these rows as CSV

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