PREVIEW / etf_30min / 2018-09-19

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-09-19.parquet
  size:    468 KB
  rows:    16,178

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-19 04:00:00	SPY	ETF	290.89	291.04	290.88	290.9	4354.0
2018-09-19 04:30:00	SPY	ETF	290.93	290.93	290.78	290.83	1600.0
2018-09-19 05:00:00	SPY	ETF	290.82	290.84	290.76	290.79	5700.0
2018-09-19 05:30:00	SPY	ETF	290.84	290.85	290.83	290.83	800.0
2018-09-19 06:00:00	SPY	ETF	290.81	290.82	290.76	290.78	3850.0
2018-09-19 06:30:00	SPY	ETF	290.87	290.89	290.86	290.89	5600.0
2018-09-19 07:00:00	SPY	ETF	290.84	290.86	290.68	290.72	28583.0
2018-09-19 07:30:00	SPY	ETF	290.74	290.79	290.63	290.64	12974.0
2018-09-19 08:00:00	SPY	ETF	290.71	291.1	290.38	290.56	158437.0
2018-09-19 08:30:00	SPY	ETF	290.59	290.74	290.51	290.69	159480.0
2018-09-19 09:00:00	SPY	ETF	290.69	290.98	290.63	290.98	236045.0
2018-09-19 09:30:00	SPY	ETF	290.97	291.53	290.95	291.2	4719241.0
2018-09-19 10:00:00	SPY	ETF	291.2	291.48	290.825	291.04	6034350.0
2018-09-19 10:30:00	SPY	ETF	291.04	291.31	290.99	291.09	3087185.0
2018-09-19 11:00:00	SPY	ETF	291.1	291.69	291.01	291.34	3922649.0
2018-09-19 11:30:00	SPY	ETF	291.3399	291.54	291.21	291.4899	2818166.0
2018-09-19 12:00:00	SPY	ETF	291.49	291.56	291.26	291.33	1380724.0
2018-09-19 12:30:00	SPY	ETF	291.33	291.43	291.06	291.39	2106160.0
2018-09-19 13:00:00	SPY	ETF	291.39	291.42	291.11	291.13	1738250.0
2018-09-19 13:30:00	SPY	ETF	291.125	291.33	291.1	291.26	1460577.0
2018-09-19 14:00:00	SPY	ETF	291.25	291.38	291.16	291.265	1340513.0
2018-09-19 14:30:00	SPY	ETF	291.265	291.28	291.11	291.12	2709700.0
2018-09-19 15:00:00	SPY	ETF	291.13	291.35	291.08	291.265	2575394.0
2018-09-19 15:30:00	SPY	ETF	291.265	291.47	291.23	291.25	7426421.0
2018-09-19 16:00:00	SPY	ETF	291.25	291.35	291.19	291.31	4480676.0
2018-09-19 16:30:00	SPY	ETF	291.32	291.47	291.22	291.47	408294.0
2018-09-19 17:00:00	SPY	ETF	291.46	291.46	291.37	291.39	388155.0
2018-09-19 17:30:00	SPY	ETF	291.43	291.43	291.38	291.43	7812.0
2018-09-19 18:00:00	SPY	ETF	291.44	291.45	291.39	291.4	45734.0
2018-09-19 18:30:00	SPY	ETF	291.39	291.44	291.38	291.44	12280.0
2018-09-19 19:00:00	SPY	ETF	291.44	291.52	291.41	291.49	6929.0
2018-09-19 19:30:00	SPY	ETF	291.49	291.59	291.49	291.58	38460.0
2018-09-19 04:00:00	QQQ	ETF	182.9	183.0	182.9	182.96	4400.0
2018-09-19 04:30:00	QQQ	ETF	182.86	182.86	182.82	182.83	2081.0
2018-09-19 05:00:00	QQQ	ETF	182.84	182.86	182.84	182.86	1211.0
2018-09-19 05:30:00	QQQ	ETF	182.89	182.9	182.8	182.8	9618.0
2018-09-19 06:00:00	QQQ	ETF	182.79	182.8	182.75	182.79	6052.0
2018-09-19 06:30:00	QQQ	ETF	182.84	182.84	182.84	182.84	500.0
2018-09-19 07:00:00	QQQ	ETF	182.81	182.86	182.69	182.73	14510.0
2018-09-19 07:30:00	QQQ	ETF	182.72	182.72	182.5	182.5	6399.0
2018-09-19 08:00:00	QQQ	ETF	182.61	182.83	182.37	182.52	191764.0
2018-09-19 08:30:00	QQQ	ETF	182.57	182.74	182.5	182.6999	143128.0
2018-09-19 09:00:00	QQQ	ETF	182.66	182.9	182.66	182.851	55175.0
2018-09-19 09:30:00	QQQ	ETF	182.86	183.3	182.035	182.19	4232139.0
2018-09-19 10:00:00	QQQ	ETF	182.18	182.48	181.51	181.8	4861564.0
2018-09-19 10:30:00	QQQ	ETF	181.79	182.06	181.57	181.74	2640455.0
2018-09-19 11:00:00	QQQ	ETF	181.74	182.66	181.62	182.28	2497734.0
2018-09-19 11:30:00	QQQ	ETF	182.29	182.46	182.08	182.41	1394480.0
2018-09-19 12:00:00	QQQ	ETF	182.401	182.5	182.12	182.16	1095803.0
2018-09-19 12:30:00	QQQ	ETF	182.1533	182.23	181.841	182.21	1090854.0

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

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