PREVIEW / etf_30min / 2018-10-17

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-10-17.parquet
  size:    486 KB
  rows:    16,820

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-17 04:00:00	SPY	ETF	280.9	281.0	280.61	280.65	34419.0
2018-10-17 04:30:00	SPY	ETF	280.72	280.81	280.53	280.58	22245.0
2018-10-17 05:00:00	SPY	ETF	280.6	280.61	280.33	280.36	23633.0
2018-10-17 05:30:00	SPY	ETF	280.36	280.42	280.09	280.3	67170.0
2018-10-17 06:00:00	SPY	ETF	280.25	280.29	279.93	280.1	84700.0
2018-10-17 06:30:00	SPY	ETF	280.1	280.28	280.07	280.22	40954.0
2018-10-17 07:00:00	SPY	ETF	280.28	280.46	280.02	280.12	104479.0
2018-10-17 07:30:00	SPY	ETF	280.08	280.2	279.79	279.9	124501.0
2018-10-17 08:00:00	SPY	ETF	279.9	281.43	279.64	279.75	255432.0
2018-10-17 08:30:00	SPY	ETF	279.8	280.09	279.65	280.05	267378.0
2018-10-17 09:00:00	SPY	ETF	280.04	280.51	279.82	280.42	567112.0
2018-10-17 09:30:00	SPY	ETF	280.44	280.46	279.13	279.1308	8533946.0
2018-10-17 10:00:00	SPY	ETF	279.14	279.48	278.51	278.93	8564988.0
2018-10-17 10:30:00	SPY	ETF	278.92	279.08	277.56	278.21	10045659.0
2018-10-17 11:00:00	SPY	ETF	278.205	280.4308	277.79	279.23	6756886.0
2018-10-17 11:30:00	SPY	ETF	279.23	280.29	278.8575	280.27	6133785.0
2018-10-17 12:00:00	SPY	ETF	280.28	280.9	279.98	280.48	7144449.0
2018-10-17 12:30:00	SPY	ETF	280.4889	281.0	280.12	280.66	5258037.0
2018-10-17 13:00:00	SPY	ETF	280.67	281.15	280.55	280.76	3937873.0
2018-10-17 13:30:00	SPY	ETF	280.77	281.08	280.52	280.765	5212972.0
2018-10-17 14:00:00	SPY	ETF	280.78	280.97	279.19	279.58	6972600.0
2018-10-17 14:30:00	SPY	ETF	279.59	280.97	279.39	280.675	5293002.0
2018-10-17 15:00:00	SPY	ETF	280.68	280.79	280.0	280.52	6876456.0
2018-10-17 15:30:00	SPY	ETF	280.52	280.62	279.39	280.4	14238476.0
2018-10-17 16:00:00	SPY	ETF	280.41	280.98	280.357	280.85	10192876.0
2018-10-17 16:30:00	SPY	ETF	280.86	280.92	280.45	280.82	692320.0
2018-10-17 17:00:00	SPY	ETF	280.8	280.8	280.63	280.6499	52778.0
2018-10-17 17:30:00	SPY	ETF	280.65	280.65	280.51	280.51	75780.0
2018-10-17 18:00:00	SPY	ETF	280.55	280.61	280.18	280.23	142672.0
2018-10-17 18:30:00	SPY	ETF	280.23	280.29	280.17	280.27	50539.0
2018-10-17 19:00:00	SPY	ETF	280.27	280.27	280.07	280.18	50168.0
2018-10-17 19:30:00	SPY	ETF	280.17	280.19	279.9	279.98	60247.0
2018-10-17 04:00:00	QQQ	ETF	178.57	178.57	178.28	178.36	53419.0
2018-10-17 04:30:00	QQQ	ETF	178.37	178.48	178.29	178.32	28447.0
2018-10-17 05:00:00	QQQ	ETF	178.33	178.33	178.08	178.12	71055.0
2018-10-17 05:30:00	QQQ	ETF	178.12	178.16	178.01	178.16	50837.0
2018-10-17 06:00:00	QQQ	ETF	178.16	178.16	177.9	178.05	66607.0
2018-10-17 06:30:00	QQQ	ETF	178.07	178.31	178.06	178.24	57807.0
2018-10-17 07:00:00	QQQ	ETF	178.27	178.4	178.0	178.0	32949.0
2018-10-17 07:30:00	QQQ	ETF	178.08	178.09	177.79	177.85	137251.0
2018-10-17 08:00:00	QQQ	ETF	178.3699	178.4	177.66	177.69	165114.0
2018-10-17 08:30:00	QQQ	ETF	177.73	177.94	177.6	177.86	259579.0
2018-10-17 09:00:00	QQQ	ETF	177.85	178.21	177.65	178.16	280089.0
2018-10-17 09:30:00	QQQ	ETF	178.15	178.2585	176.4875	176.61	7209257.0
2018-10-17 10:00:00	QQQ	ETF	176.6	176.86	176.02	176.57	5549180.0
2018-10-17 10:30:00	QQQ	ETF	176.53	176.73	175.47	176.01	5672743.0
2018-10-17 11:00:00	QQQ	ETF	176.0	176.74	175.71	176.69	3974612.0
2018-10-17 11:30:00	QQQ	ETF	176.7	177.24	176.165	177.09	3860822.0
2018-10-17 12:00:00	QQQ	ETF	177.11	177.55	176.74	177.04	3283255.0
2018-10-17 12:30:00	QQQ	ETF	177.05	177.51	176.66	177.22	2708072.0

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

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