PREVIEW / etf_30min / 2018-10-09

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-10-09.parquet
  size:    482 KB
  rows:    16,448

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-10-09 04:00:00	SPY	ETF	287.59	287.6	287.4	287.4	32580.0
2018-10-09 04:30:00	SPY	ETF	287.35	287.55	287.35	287.5	8500.0
2018-10-09 05:00:00	SPY	ETF	287.5	287.5	287.2	287.21	8896.0
2018-10-09 05:30:00	SPY	ETF	287.16	287.21	286.86	286.86	28240.0
2018-10-09 06:00:00	SPY	ETF	286.84	286.99	286.68	286.89	26315.0
2018-10-09 06:30:00	SPY	ETF	286.92	287.17	286.88	287.09	20500.0
2018-10-09 07:00:00	SPY	ETF	287.17	287.18	286.49	286.67	168712.0
2018-10-09 07:30:00	SPY	ETF	286.7	286.75	286.34	286.38	220417.0
2018-10-09 08:00:00	SPY	ETF	286.6	287.93	286.38	286.87	264704.0
2018-10-09 08:30:00	SPY	ETF	286.93	287.44	286.88	287.35	395519.0
2018-10-09 09:00:00	SPY	ETF	287.36	287.41	287.13	287.39	260162.0
2018-10-09 09:30:00	SPY	ETF	287.39	287.87	286.77	287.84	7958259.0
2018-10-09 10:00:00	SPY	ETF	287.84	288.57	287.49	288.49	5181111.0
2018-10-09 10:30:00	SPY	ETF	288.51	288.86	288.02	288.0225	5069278.0
2018-10-09 11:00:00	SPY	ETF	288.02	288.48	287.53	288.355	5392978.0
2018-10-09 11:30:00	SPY	ETF	288.35	288.6	288.06	288.525	2661809.0
2018-10-09 12:00:00	SPY	ETF	288.53	288.75	287.85	287.895	2959297.0
2018-10-09 12:30:00	SPY	ETF	287.89	288.13	287.18	287.46	8182661.0
2018-10-09 13:00:00	SPY	ETF	287.45	287.95	287.03	287.725	3523586.0
2018-10-09 13:30:00	SPY	ETF	287.72	287.86	287.13	287.6701	2494315.0
2018-10-09 14:00:00	SPY	ETF	287.68	287.97	287.36	287.86	4078715.0
2018-10-09 14:30:00	SPY	ETF	287.87	288.19	287.48	288.0849	3383705.0
2018-10-09 15:00:00	SPY	ETF	288.08	288.15	287.35	287.4928	2981103.0
2018-10-09 15:30:00	SPY	ETF	287.49	287.99	287.37	287.43	11274933.0
2018-10-09 16:00:00	SPY	ETF	287.42	287.7	287.29	287.65	6287548.0
2018-10-09 16:30:00	SPY	ETF	287.64	287.72	287.53	287.6	136642.0
2018-10-09 17:00:00	SPY	ETF	287.6	287.61	287.28	287.4	194830.0
2018-10-09 17:30:00	SPY	ETF	287.41	287.5	287.41	287.49	21356.0
2018-10-09 18:00:00	SPY	ETF	287.49	287.77	287.49	287.77	104501.0
2018-10-09 18:30:00	SPY	ETF	287.77	287.82	287.75	287.77	68625.0
2018-10-09 19:00:00	SPY	ETF	287.79	287.89	287.79	287.89	6602.0
2018-10-09 19:30:00	SPY	ETF	287.88	287.88	287.71	287.77	17744.0
2018-10-09 04:00:00	QQQ	ETF	179.1	179.11	178.86	178.95	38182.0
2018-10-09 04:30:00	QQQ	ETF	178.92	179.06	178.92	179.06	3077.0
2018-10-09 05:00:00	QQQ	ETF	178.93	179.0	178.88	178.88	1700.0
2018-10-09 05:30:00	QQQ	ETF	178.78	178.81	178.6	178.63	32320.0
2018-10-09 06:00:00	QQQ	ETF	178.62	178.68	178.46	178.66	12980.0
2018-10-09 06:30:00	QQQ	ETF	178.65	178.85	178.64	178.82	31283.0
2018-10-09 07:00:00	QQQ	ETF	178.85	178.89	178.33	178.45	97063.0
2018-10-09 07:30:00	QQQ	ETF	178.46	178.49	178.17	178.23	109515.0
2018-10-09 08:00:00	QQQ	ETF	178.24	179.43	178.2	178.6	283358.0
2018-10-09 08:30:00	QQQ	ETF	178.63	179.2	178.63	179.12	351367.0
2018-10-09 09:00:00	QQQ	ETF	179.13	179.19	178.88	179.17	292384.0
2018-10-09 09:30:00	QQQ	ETF	179.18	180.0	178.75	179.94	7865833.0
2018-10-09 10:00:00	QQQ	ETF	179.94	180.56	179.27	180.52	4790759.0
2018-10-09 10:30:00	QQQ	ETF	180.54	181.02	180.3	180.32	4614451.0
2018-10-09 11:00:00	QQQ	ETF	180.33	180.685	179.69	180.48	4106040.0
2018-10-09 11:30:00	QQQ	ETF	180.48	180.66	180.23	180.4781	1796520.0
2018-10-09 12:00:00	QQQ	ETF	180.5	180.69	179.8	179.83	2083289.0
2018-10-09 12:30:00	QQQ	ETF	179.82	180.09	179.28	179.42	2623492.0

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

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