PREVIEW / etf_30min / 2018-09-14

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-09-14.parquet
  size:    464 KB
  rows:    15,968

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-09-14 04:00:00	SPY	ETF	291.18	291.38	290.97	291.35	19419.0
2018-09-14 04:30:00	SPY	ETF	291.27	291.27	291.21	291.21	10150.0
2018-09-14 05:00:00	SPY	ETF	291.35	291.4	291.32	291.35	500.0
2018-09-14 05:30:00	SPY	ETF	291.39	291.39	291.3	291.33	2500.0
2018-09-14 06:00:00	SPY	ETF	291.2	291.4	291.2	291.36	5200.0
2018-09-14 06:30:00	SPY	ETF	291.3	291.33	291.18	291.33	6590.0
2018-09-14 07:00:00	SPY	ETF	291.31	291.49	291.28	291.43	47558.0
2018-09-14 07:30:00	SPY	ETF	291.4	291.45	291.33	291.37	105229.0
2018-09-14 08:00:00	SPY	ETF	291.2801	291.37	290.84	291.23	56382.0
2018-09-14 08:30:00	SPY	ETF	291.23	291.32	291.11	291.13	158024.0
2018-09-14 09:00:00	SPY	ETF	291.13	291.2	291.01	291.09	418482.0
2018-09-14 09:30:00	SPY	ETF	291.06	291.23	290.79	290.975	3942334.0
2018-09-14 10:00:00	SPY	ETF	290.97	291.01	290.52	290.83	3588302.0
2018-09-14 10:30:00	SPY	ETF	290.83	291.14	290.83	291.035	3061655.0
2018-09-14 11:00:00	SPY	ETF	291.04	291.25	290.92	291.109	2846180.0
2018-09-14 11:30:00	SPY	ETF	291.11	291.27	291.02	291.165	1516955.0
2018-09-14 12:00:00	SPY	ETF	291.165	291.19	290.16	290.355	8426583.0
2018-09-14 12:30:00	SPY	ETF	290.34	290.53	290.25	290.32	2476172.0
2018-09-14 13:00:00	SPY	ETF	290.31	290.525	290.0	290.46	2518616.0
2018-09-14 13:30:00	SPY	ETF	290.47	290.65	290.45	290.63	2188635.0
2018-09-14 14:00:00	SPY	ETF	290.64	290.78	290.57	290.665	2862352.0
2018-09-14 14:30:00	SPY	ETF	290.67	290.79	290.58	290.75	1975507.0
2018-09-14 15:00:00	SPY	ETF	290.75	290.92	290.68	290.735	2629965.0
2018-09-14 15:30:00	SPY	ETF	290.75	291.12	290.73	290.9	8499696.0
2018-09-14 16:00:00	SPY	ETF	290.91	291.06	290.88	290.98	4784734.0
2018-09-14 16:30:00	SPY	ETF	290.98	291.0	290.84	290.93	242017.0
2018-09-14 17:00:00	SPY	ETF	290.94	290.98	290.71	290.97	840208.0
2018-09-14 17:30:00	SPY	ETF	290.99	291.01	290.88	290.88	925076.0
2018-09-14 18:00:00	SPY	ETF	290.9	290.91	290.8	290.81	63442.0
2018-09-14 18:30:00	SPY	ETF	290.81	290.92	290.78	290.87	42146.0
2018-09-14 19:00:00	SPY	ETF	290.85	290.9	290.85	290.9	4925.0
2018-09-14 19:30:00	SPY	ETF	290.88	290.99	290.88	290.92	12853.0
2018-09-14 04:00:00	QQQ	ETF	184.96	185.22	184.96	185.13	19794.0
2018-09-14 04:30:00	QQQ	ETF	185.14	185.19	185.09	185.18	18900.0
2018-09-14 05:00:00	QQQ	ETF	185.17	185.22	185.17	185.19	800.0
2018-09-14 05:30:00	QQQ	ETF	185.21	185.21	185.14	185.14	2228.0
2018-09-14 06:00:00	QQQ	ETF	185.01	185.17	185.0	185.09	11300.0
2018-09-14 06:30:00	QQQ	ETF	185.12	185.12	185.0	185.05	4240.0
2018-09-14 07:00:00	QQQ	ETF	185.1	185.15	185.03	185.15	47049.0
2018-09-14 07:30:00	QQQ	ETF	185.12	185.2	185.12	185.12	71671.0
2018-09-14 08:00:00	QQQ	ETF	185.13	185.19	184.92	185.01	78398.0
2018-09-14 08:30:00	QQQ	ETF	185.01	185.01	184.76	184.76	42353.0
2018-09-14 09:00:00	QQQ	ETF	184.75	184.86	184.62	184.68	143731.0
2018-09-14 09:30:00	QQQ	ETF	184.66	184.92	184.21	184.65	2839629.0
2018-09-14 10:00:00	QQQ	ETF	184.65	184.775	184.23	184.62	1937488.0
2018-09-14 10:30:00	QQQ	ETF	184.62	184.945	184.48	184.68	1559948.0
2018-09-14 11:00:00	QQQ	ETF	184.69	184.75	184.31	184.47	1730819.0
2018-09-14 11:30:00	QQQ	ETF	184.48	184.58	184.37	184.44	804412.0
2018-09-14 12:00:00	QQQ	ETF	184.44	184.475	183.37	183.49	4746170.0
2018-09-14 12:30:00	QQQ	ETF	183.48	183.86	183.39	183.66	1243442.0

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

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