PREVIEW / etf_30min / 2018-06-14

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-06-14.parquet
  size:    461 KB
  rows:    15,928

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-14 04:00:00	SPY	ETF	277.81	277.81	277.38	277.44	26195.0
2018-06-14 04:30:00	SPY	ETF	277.58	277.85	277.58	277.8	18422.0
2018-06-14 05:00:00	SPY	ETF	277.83	277.95	277.83	277.87	6002.0
2018-06-14 05:30:00	SPY	ETF	277.88	277.88	277.73	277.82	3952.0
2018-06-14 06:00:00	SPY	ETF	277.73	277.98	277.72	277.8	19950.0
2018-06-14 06:30:00	SPY	ETF	277.81	277.88	277.68	277.83	24581.0
2018-06-14 07:00:00	SPY	ETF	277.89	278.01	277.76	278.01	53278.0
2018-06-14 07:30:00	SPY	ETF	278.01	278.42	277.92	278.28	227006.0
2018-06-14 08:00:00	SPY	ETF	278.28	278.56	277.23	278.51	556132.0
2018-06-14 08:30:00	SPY	ETF	278.51	278.84	278.43	278.65	701060.0
2018-06-14 09:00:00	SPY	ETF	278.66	279.01	278.63	278.95	774155.0
2018-06-14 09:30:00	SPY	ETF	279.01	279.12	278.57	278.7	7524091.0
2018-06-14 10:00:00	SPY	ETF	278.7	279.33	278.69	279.115	6739889.0
2018-06-14 10:30:00	SPY	ETF	279.12	279.14	278.29	278.3	5003708.0
2018-06-14 11:00:00	SPY	ETF	278.29	278.64	278.0599	278.58	5455503.0
2018-06-14 11:30:00	SPY	ETF	278.58	278.9	278.57	278.77	2561311.0
2018-06-14 12:00:00	SPY	ETF	278.77	278.89	278.59	278.5916	2298098.0
2018-06-14 12:30:00	SPY	ETF	278.5914	278.68	278.44	278.46	2277493.0
2018-06-14 13:00:00	SPY	ETF	278.47	278.88	278.39	278.82	2417823.0
2018-06-14 13:30:00	SPY	ETF	278.82	279.05	278.69	278.7	2625870.0
2018-06-14 14:00:00	SPY	ETF	278.7	278.8062	278.5	278.61	1892352.0
2018-06-14 14:30:00	SPY	ETF	278.6	278.67	278.315	278.36	2538002.0
2018-06-14 15:00:00	SPY	ETF	278.36	278.72	278.27	278.6949	3881529.0
2018-06-14 15:30:00	SPY	ETF	278.695	278.95	278.57	278.72	10517884.0
2018-06-14 16:00:00	SPY	ETF	278.7	278.84	278.03	278.77	8528992.0
2018-06-14 16:30:00	SPY	ETF	278.8	278.8	278.63	278.75	670296.0
2018-06-14 17:00:00	SPY	ETF	278.74	278.8	278.65	278.7	6032755.0
2018-06-14 17:30:00	SPY	ETF	278.72	278.78	278.61	278.61	522938.0
2018-06-14 18:00:00	SPY	ETF	278.66	278.72	278.45	278.62	123645.0
2018-06-14 18:30:00	SPY	ETF	278.64	278.69	278.44	278.6	20519.0
2018-06-14 19:00:00	SPY	ETF	278.6	278.62	278.54	278.57	5710.0
2018-06-14 19:30:00	SPY	ETF	278.56	278.71	278.56	278.71	6877.0
2018-06-14 04:00:00	QQQ	ETF	175.42	175.42	175.28	175.29	4700.0
2018-06-14 04:30:00	QQQ	ETF	175.41	175.53	175.38	175.41	9956.0
2018-06-14 05:00:00	QQQ	ETF	175.53	175.61	175.51	175.51	2450.0
2018-06-14 05:30:00	QQQ	ETF	175.55	175.55	175.37	175.39	19100.0
2018-06-14 06:00:00	QQQ	ETF	175.4	175.69	175.4	175.63	6800.0
2018-06-14 06:30:00	QQQ	ETF	175.54	175.64	175.53	175.53	1800.0
2018-06-14 07:00:00	QQQ	ETF	175.6	175.71	175.54	175.71	20195.0
2018-06-14 07:30:00	QQQ	ETF	175.71	176.24	175.71	176.1	94106.0
2018-06-14 08:00:00	QQQ	ETF	175.86	176.31	175.61	176.26	73204.0
2018-06-14 08:30:00	QQQ	ETF	176.3	176.49	176.2	176.41	266778.0
2018-06-14 09:00:00	QQQ	ETF	176.41	176.62	176.36	176.62	266971.0
2018-06-14 09:30:00	QQQ	ETF	176.62	177.16	176.5	176.8	3845427.0
2018-06-14 10:00:00	QQQ	ETF	176.8	177.6333	176.8	177.54	2935659.0
2018-06-14 10:30:00	QQQ	ETF	177.55	177.58	176.95	176.97	2114407.0
2018-06-14 11:00:00	QQQ	ETF	176.9784	177.37	176.72	177.28	2180753.0
2018-06-14 11:30:00	QQQ	ETF	177.3	177.6999	177.28	177.46	2858587.0
2018-06-14 12:00:00	QQQ	ETF	177.46	177.6	177.41	177.49	980326.0
2018-06-14 12:30:00	QQQ	ETF	177.49	177.53	177.335	177.375	930832.0

> showing 50 of 15,928 rows — these rows as CSV

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