PREVIEW / etf_30min / 2018-06-25

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-06-25.parquet
  size:    484 KB
  rows:    16,744

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-06-25 04:00:00	SPY	ETF	273.5	273.79	273.39	273.39	32744.0
2018-06-25 04:30:00	SPY	ETF	273.38	273.56	273.19	273.19	8857.0
2018-06-25 05:00:00	SPY	ETF	273.25	273.32	273.1	273.32	18260.0
2018-06-25 05:30:00	SPY	ETF	273.3	273.41	273.25	273.36	14100.0
2018-06-25 06:00:00	SPY	ETF	273.42	273.5	272.95	273.12	97505.0
2018-06-25 06:30:00	SPY	ETF	273.16	273.31	272.93	273.3	112102.0
2018-06-25 07:00:00	SPY	ETF	273.27	273.63	273.21	273.39	129524.0
2018-06-25 07:30:00	SPY	ETF	273.38	273.61	273.35	273.6	149063.0
2018-06-25 08:00:00	SPY	ETF	273.6	273.74	273.2	273.72	215257.0
2018-06-25 08:30:00	SPY	ETF	273.7	273.7	273.51	273.6	238480.0
2018-06-25 09:00:00	SPY	ETF	273.6	273.64	273.4	273.42	485148.0
2018-06-25 09:30:00	SPY	ETF	273.44	273.6162	271.98	272.03	10414960.0
2018-06-25 10:00:00	SPY	ETF	272.02	272.2	271.06	271.67	10975467.0
2018-06-25 10:30:00	SPY	ETF	271.66	272.17	271.41	271.5554	8708023.0
2018-06-25 11:00:00	SPY	ETF	271.55	271.72	270.53	270.54	6379009.0
2018-06-25 11:30:00	SPY	ETF	270.54	270.9698	270.2	270.625	9704664.0
2018-06-25 12:00:00	SPY	ETF	270.62	270.695	269.45	270.39	9147177.0
2018-06-25 12:30:00	SPY	ETF	270.4	270.86	270.08	270.805	4373450.0
2018-06-25 13:00:00	SPY	ETF	270.8	270.82	269.97	270.33	5195786.0
2018-06-25 13:30:00	SPY	ETF	270.33	271.21	270.32	270.73	4755614.0
2018-06-25 14:00:00	SPY	ETF	270.73	270.88	270.29	270.47	2841734.0
2018-06-25 14:30:00	SPY	ETF	270.46	270.46	269.1	269.58	8323414.0
2018-06-25 15:00:00	SPY	ETF	269.58	270.1	269.3	269.8625	7357254.0
2018-06-25 15:30:00	SPY	ETF	269.87	271.51	269.67	271.01	24628637.0
2018-06-25 16:00:00	SPY	ETF	271.01	271.37	270.45	271.13	16649073.0
2018-06-25 16:30:00	SPY	ETF	271.14	271.31	270.9755	271.26	2275193.0
2018-06-25 17:00:00	SPY	ETF	271.21	271.25	270.5581	271.16	828863.0
2018-06-25 17:30:00	SPY	ETF	271.15	271.16	271.05	271.05	283411.0
2018-06-25 18:00:00	SPY	ETF	271.12	271.38	271.12	271.24	321205.0
2018-06-25 18:30:00	SPY	ETF	271.26	271.27	271.12	271.25	43549.0
2018-06-25 19:00:00	SPY	ETF	271.26	271.4	271.2	271.2	4501.0
2018-06-25 19:30:00	SPY	ETF	271.18	271.26	271.02	271.08	35090.0
2018-06-25 04:00:00	QQQ	ETF	174.72	174.72	174.0	174.0	37916.0
2018-06-25 04:30:00	QQQ	ETF	173.95	174.03	173.87	173.88	5397.0
2018-06-25 05:00:00	QQQ	ETF	173.83	173.83	173.61	173.75	17937.0
2018-06-25 05:30:00	QQQ	ETF	173.72	174.0	173.69	173.69	19294.0
2018-06-25 06:00:00	QQQ	ETF	173.73	173.85	173.49	173.56	20352.0
2018-06-25 06:30:00	QQQ	ETF	173.57	173.6	173.37	173.6	15740.0
2018-06-25 07:00:00	QQQ	ETF	173.6	173.97	173.57	173.7	104765.0
2018-06-25 07:30:00	QQQ	ETF	173.75	173.9	173.6	173.77	63093.0
2018-06-25 08:00:00	QQQ	ETF	173.6	174.03	173.57	173.99	226692.0
2018-06-25 08:30:00	QQQ	ETF	174.04	174.1	173.85	173.85	129358.0
2018-06-25 09:00:00	QQQ	ETF	173.85	173.85	173.69	173.77	269397.0
2018-06-25 09:30:00	QQQ	ETF	173.77	173.99	172.57	172.75	6455223.0
2018-06-25 10:00:00	QQQ	ETF	172.74	172.995	171.81	172.2	6707177.0
2018-06-25 10:30:00	QQQ	ETF	172.2	172.62	171.75	171.88	5067609.0
2018-06-25 11:00:00	QQQ	ETF	171.89	172.055	171.2	171.2266	3528604.0
2018-06-25 11:30:00	QQQ	ETF	171.2227	171.42	170.9839	171.1838	4222422.0
2018-06-25 12:00:00	QQQ	ETF	171.18	171.26	170.07	170.76	5448501.0
2018-06-25 12:30:00	QQQ	ETF	170.76	170.85	170.27	170.82	3152212.0

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

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