PREVIEW / etf_30min / 2018-04-11

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-04-11.parquet
  size:    460 KB
  rows:    15,845

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-04-11 04:00:00	SPY	ETF	263.9	263.9	263.36	263.5	19899.0
2018-04-11 04:30:00	SPY	ETF	263.52	263.75	263.52	263.62	12840.0
2018-04-11 05:00:00	SPY	ETF	263.65	263.77	263.65	263.76	7490.0
2018-04-11 05:30:00	SPY	ETF	263.75	263.81	263.64	263.64	3410.0
2018-04-11 06:00:00	SPY	ETF	263.64	263.71	262.48	262.87	62283.0
2018-04-11 06:30:00	SPY	ETF	262.88	263.13	262.5	262.87	108955.0
2018-04-11 07:00:00	SPY	ETF	262.9	262.93	262.15	262.24	444342.0
2018-04-11 07:30:00	SPY	ETF	262.28	263.08	262.19	263.08	622397.0
2018-04-11 08:00:00	SPY	ETF	263.03	263.79	262.22	262.83	457387.0
2018-04-11 08:30:00	SPY	ETF	262.83	263.02	262.62	262.78	545973.0
2018-04-11 09:00:00	SPY	ETF	262.81	263.49	262.66	263.48	682209.0
2018-04-11 09:30:00	SPY	ETF	263.47	264.56	263.41	264.48	9394882.0
2018-04-11 10:00:00	SPY	ETF	264.47	264.83	264.0108	264.78	6445791.0
2018-04-11 10:30:00	SPY	ETF	264.78	264.96	263.86	263.89	9438142.0
2018-04-11 11:00:00	SPY	ETF	263.88	264.43	263.55	264.34	4864549.0
2018-04-11 11:30:00	SPY	ETF	264.33	265.23	264.21	264.925	5134709.0
2018-04-11 12:00:00	SPY	ETF	264.925	265.64	264.8908	265.165	4112259.0
2018-04-11 12:30:00	SPY	ETF	265.16	265.28	264.4	264.63	3861922.0
2018-04-11 13:00:00	SPY	ETF	264.63	265.0	264.25	264.59	4650681.0
2018-04-11 13:30:00	SPY	ETF	264.59	264.81	264.12	264.6986	3459870.0
2018-04-11 14:00:00	SPY	ETF	264.7	265.01	263.96	264.42	5932667.0
2018-04-11 14:30:00	SPY	ETF	264.38	264.96	264.0	264.47	4311768.0
2018-04-11 15:00:00	SPY	ETF	264.46	264.6	263.39	263.78	8121696.0
2018-04-11 15:30:00	SPY	ETF	263.77	264.22	263.53	263.75	8670549.0
2018-04-11 16:00:00	SPY	ETF	263.75	263.77	263.54	263.64	7718982.0
2018-04-11 16:30:00	SPY	ETF	263.63	263.83	263.62	263.78	529331.0
2018-04-11 17:00:00	SPY	ETF	263.78	263.79	263.6	263.67	141692.0
2018-04-11 17:30:00	SPY	ETF	263.68	263.8	263.65	263.73	59271.0
2018-04-11 18:00:00	SPY	ETF	263.76	264.06	263.74	263.74	16145.0
2018-04-11 18:30:00	SPY	ETF	263.77	264.2	263.77	264.1	25158.0
2018-04-11 19:00:00	SPY	ETF	264.15	264.3	264.14	264.29	11058.0
2018-04-11 19:30:00	SPY	ETF	264.26	264.32	264.08	264.27	30777.0
2018-04-11 04:00:00	QQQ	ETF	160.4	160.4	160.11	160.18	3466.0
2018-04-11 04:30:00	QQQ	ETF	160.22	160.34	160.22	160.28	4281.0
2018-04-11 05:00:00	QQQ	ETF	160.35	160.4	160.28	160.4	13000.0
2018-04-11 05:30:00	QQQ	ETF	160.41	160.45	160.28	160.31	9500.0
2018-04-11 06:00:00	QQQ	ETF	160.33	160.33	159.4	159.63	23647.0
2018-04-11 06:30:00	QQQ	ETF	159.63	159.91	159.53	159.74	89488.0
2018-04-11 07:00:00	QQQ	ETF	159.79	159.85	159.36	159.4	154667.0
2018-04-11 07:30:00	QQQ	ETF	159.35	159.87	159.32	159.87	213050.0
2018-04-11 08:00:00	QQQ	ETF	159.52	159.95	159.4	159.75	144563.0
2018-04-11 08:30:00	QQQ	ETF	159.8	159.96	159.61	159.78	226572.0
2018-04-11 09:00:00	QQQ	ETF	159.81	160.25	159.71	160.25	308131.0
2018-04-11 09:30:00	QQQ	ETF	160.24	160.94	160.14	160.8823	4712736.0
2018-04-11 10:00:00	QQQ	ETF	160.88	161.4	160.3	161.33	2894917.0
2018-04-11 10:30:00	QQQ	ETF	161.32	161.5399	160.72	160.7495	2159192.0
2018-04-11 11:00:00	QQQ	ETF	160.75	161.08	160.39	160.99	1768053.0
2018-04-11 11:30:00	QQQ	ETF	160.98	161.64	160.81	161.38	2090004.0
2018-04-11 12:00:00	QQQ	ETF	161.37	162.0	161.35	161.57	2203924.0
2018-04-11 12:30:00	QQQ	ETF	161.56	161.64	160.89	161.0099	1748851.0

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

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