PREVIEW / etf_30min / 2019-08-13

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-08-13.parquet
  size:    519 KB
  rows:    18,175

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
2019-08-13 04:00:00	SPY	ETF	287.2	287.6	287.12	287.5	11404.0
2019-08-13 04:30:00	SPY	ETF	287.47	288.02	287.4	288.02	2381.0
2019-08-13 05:00:00	SPY	ETF	287.88	287.88	286.78	286.88	11146.0
2019-08-13 05:30:00	SPY	ETF	286.72	286.99	286.5	286.78	23791.0
2019-08-13 06:00:00	SPY	ETF	286.82	287.38	286.66	287.38	9788.0
2019-08-13 06:30:00	SPY	ETF	287.29	287.67	287.19	287.66	60149.0
2019-08-13 07:00:00	SPY	ETF	287.68	287.88	287.22	287.32	206146.0
2019-08-13 07:30:00	SPY	ETF	287.35	287.35	286.99	287.18	113333.0
2019-08-13 08:00:00	SPY	ETF	287.7799	288.43	286.98	287.4	291290.0
2019-08-13 08:30:00	SPY	ETF	287.4	287.4	286.55	287.2	514822.0
2019-08-13 09:00:00	SPY	ETF	287.22	288.07	287.02	287.74	475395.0
2019-08-13 09:30:00	SPY	ETF	287.74	293.5	287.36	292.97	21486518.0
2019-08-13 10:00:00	SPY	ETF	292.93	294.15	292.0	293.78	11517049.0
2019-08-13 10:30:00	SPY	ETF	293.77	293.89	292.33	292.34	6497769.0
2019-08-13 11:00:00	SPY	ETF	292.32	292.98	291.49	291.84	6079754.0
2019-08-13 11:30:00	SPY	ETF	291.83	292.94	291.48	292.89	3933096.0
2019-08-13 12:00:00	SPY	ETF	292.91	293.459	292.54	292.95	2968266.0
2019-08-13 12:30:00	SPY	ETF	292.98	293.04	292.36	292.65	2324485.0
2019-08-13 13:00:00	SPY	ETF	292.66	293.17	291.98	292.58	5178409.0
2019-08-13 13:30:00	SPY	ETF	292.57	292.8	292.38	292.67	1709466.0
2019-08-13 14:00:00	SPY	ETF	292.68	293.1	292.56	293.06	2490343.0
2019-08-13 14:30:00	SPY	ETF	293.06	293.33	292.86	292.89	3547922.0
2019-08-13 15:00:00	SPY	ETF	292.87	293.02	292.42	292.72	4160526.0
2019-08-13 15:30:00	SPY	ETF	292.72	292.72	292.11	292.43	10462232.0
2019-08-13 16:00:00	SPY	ETF	292.42	293.04	292.32	292.97	2584574.0
2019-08-13 16:30:00	SPY	ETF	292.96	293.15	292.55	292.91	4649912.0
2019-08-13 17:00:00	SPY	ETF	292.9	292.9	292.55	292.82	492938.0
2019-08-13 17:30:00	SPY	ETF	292.83	292.84	292.75	292.77	316321.0
2019-08-13 18:00:00	SPY	ETF	292.82	292.89	292.61	292.81	94634.0
2019-08-13 18:30:00	SPY	ETF	292.81	292.98	292.78	292.92	60179.0
2019-08-13 19:00:00	SPY	ETF	292.93	293.07	292.92	293.06	20255.0
2019-08-13 19:30:00	SPY	ETF	293.0	293.0	292.73	292.94	43562.0
2019-08-13 04:00:00	QQQ	ETF	183.64	184.04	183.64	183.94	14020.0
2019-08-13 04:30:00	QQQ	ETF	183.82	184.28	183.82	184.27	6370.0
2019-08-13 05:00:00	QQQ	ETF	183.98	184.0	183.24	183.36	24332.0
2019-08-13 05:30:00	QQQ	ETF	183.18	183.4	183.02	183.39	16703.0
2019-08-13 06:00:00	QQQ	ETF	183.3	183.77	183.18	183.65	15365.0
2019-08-13 06:30:00	QQQ	ETF	183.68	184.1	183.68	184.08	17548.0
2019-08-13 07:00:00	QQQ	ETF	184.09	184.27	183.75	183.86	42671.0
2019-08-13 07:30:00	QQQ	ETF	183.85	183.86	183.6	183.77	41833.0
2019-08-13 08:00:00	QQQ	ETF	184.14	184.47	183.5	183.99	92371.0
2019-08-13 08:30:00	QQQ	ETF	183.93	183.93	183.37	183.79	170441.0
2019-08-13 09:00:00	QQQ	ETF	183.79	184.3	183.63	184.29	129644.0
2019-08-13 09:30:00	QQQ	ETF	184.28	189.32	184.02	189.07	7902221.0
2019-08-13 10:00:00	QQQ	ETF	189.03	189.68	188.18	189.39	4773953.0
2019-08-13 10:30:00	QQQ	ETF	189.38	189.5	188.22	188.23	3068484.0
2019-08-13 11:00:00	QQQ	ETF	188.21	188.66	187.41	187.72	2966642.0
2019-08-13 11:30:00	QQQ	ETF	187.71	188.53	187.37	188.5	1828792.0
2019-08-13 12:00:00	QQQ	ETF	188.52	188.77	188.26	188.41	1506724.0
2019-08-13 12:30:00	QQQ	ETF	188.41	188.5	188.02	188.235	892801.0

> showing 50 of 18,175 rows — these rows as CSV

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