PREVIEW / etf_30min / 2018-10-04

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-10-04.parquet
  size:    505 KB
  rows:    17,383

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-04 04:00:00	SPY	ETF	290.7	291.25	290.26	290.29	72174.0
2018-10-04 04:30:00	SPY	ETF	290.31	290.45	290.21	290.4	54511.0
2018-10-04 05:00:00	SPY	ETF	290.39	290.54	290.18	290.54	7770.0
2018-10-04 05:30:00	SPY	ETF	290.61	290.68	290.5	290.5	22820.0
2018-10-04 06:00:00	SPY	ETF	290.55	290.83	290.55	290.7	8237.0
2018-10-04 06:30:00	SPY	ETF	290.72	290.94	290.68	290.92	18480.0
2018-10-04 07:00:00	SPY	ETF	290.92	291.04	290.87	290.91	65257.0
2018-10-04 07:30:00	SPY	ETF	290.91	290.95	290.75	290.91	188529.0
2018-10-04 08:00:00	SPY	ETF	291.72	291.72	290.26	290.83	219575.0
2018-10-04 08:30:00	SPY	ETF	290.79	291.1	290.6	291.02	311425.0
2018-10-04 09:00:00	SPY	ETF	291.02	291.23	290.94	291.19	311913.0
2018-10-04 09:30:00	SPY	ETF	291.18	291.24	290.63	290.74	6777270.0
2018-10-04 10:00:00	SPY	ETF	290.73	290.74	289.43	289.68	8294364.0
2018-10-04 10:30:00	SPY	ETF	289.6711	290.02	289.45	289.69	7030210.0
2018-10-04 11:00:00	SPY	ETF	289.6877	290.18	289.64	289.71	4062591.0
2018-10-04 11:30:00	SPY	ETF	289.7	289.835	289.17	289.21	7003338.0
2018-10-04 12:00:00	SPY	ETF	289.215	289.37	288.28	288.66	8626369.0
2018-10-04 12:30:00	SPY	ETF	288.66	289.33	288.61	288.765	6961594.0
2018-10-04 13:00:00	SPY	ETF	288.76	288.845	288.05	288.37	6570657.0
2018-10-04 13:30:00	SPY	ETF	288.37	288.54	287.93	288.15	6679160.0
2018-10-04 14:00:00	SPY	ETF	288.14	288.38	287.66	288.06	7187652.0
2018-10-04 14:30:00	SPY	ETF	288.041	289.16	287.921	289.0625	7511422.0
2018-10-04 15:00:00	SPY	ETF	289.06	289.42	288.84	288.85	6177591.0
2018-10-04 15:30:00	SPY	ETF	288.85	289.67	288.62	289.47	14381401.0
2018-10-04 16:00:00	SPY	ETF	289.49	289.71	288.25	289.58	10330898.0
2018-10-04 16:30:00	SPY	ETF	289.56	289.88	289.4466	289.88	763998.0
2018-10-04 17:00:00	SPY	ETF	289.87	289.87	289.71	289.79	198909.0
2018-10-04 17:30:00	SPY	ETF	289.82	289.91	289.81	289.85	81107.0
2018-10-04 18:00:00	SPY	ETF	289.84	289.9	289.71	289.71	70484.0
2018-10-04 18:30:00	SPY	ETF	289.8	289.8	289.66	289.69	24795.0
2018-10-04 19:00:00	SPY	ETF	289.72	289.76	289.64	289.71	30330.0
2018-10-04 19:30:00	SPY	ETF	289.7	289.94	289.7	289.88	41180.0
2018-10-04 04:00:00	QQQ	ETF	185.23	185.23	184.73	184.73	13150.0
2018-10-04 04:30:00	QQQ	ETF	184.71	184.86	184.7	184.83	15424.0
2018-10-04 05:00:00	QQQ	ETF	184.64	184.89	184.56	184.83	22554.0
2018-10-04 05:30:00	QQQ	ETF	184.93	184.96	184.79	184.79	11161.0
2018-10-04 06:00:00	QQQ	ETF	184.96	185.05	184.93	185.0	15385.0
2018-10-04 06:30:00	QQQ	ETF	184.95	185.03	184.94	184.99	9434.0
2018-10-04 07:00:00	QQQ	ETF	185.13	185.24	185.1	185.14	55237.0
2018-10-04 07:30:00	QQQ	ETF	185.13	185.18	184.9	185.08	130916.0
2018-10-04 08:00:00	QQQ	ETF	185.08	185.19	184.77	184.97	100337.0
2018-10-04 08:30:00	QQQ	ETF	184.93	185.22	184.83	185.15	183107.0
2018-10-04 09:00:00	QQQ	ETF	185.14	185.3	185.09	185.17	114216.0
2018-10-04 09:30:00	QQQ	ETF	185.22	185.32	183.95	184.3	6041530.0
2018-10-04 10:00:00	QQQ	ETF	184.29	184.3	183.12	183.24	5366957.0
2018-10-04 10:30:00	QQQ	ETF	183.24	183.46	182.96	183.1	3689930.0
2018-10-04 11:00:00	QQQ	ETF	183.1	183.56	183.03	183.1	2975574.0
2018-10-04 11:30:00	QQQ	ETF	183.1	183.18	182.48	182.58	3427741.0
2018-10-04 12:00:00	QQQ	ETF	182.5893	182.74	181.8	182.05	5668691.0
2018-10-04 12:30:00	QQQ	ETF	182.05	182.46	181.83	181.98	4173269.0

> showing 50 of 17,383 rows — these rows as CSV

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