PREVIEW / etf_30min / 2019-08-15

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-08-15.parquet
  size:    532 KB
  rows:    18,674

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
2019-08-15 04:00:00	SPY	ETF	285.55	286.0	285.37	286.0	28569.0
2019-08-15 04:30:00	SPY	ETF	285.9	286.25	285.75	285.75	20943.0
2019-08-15 05:00:00	SPY	ETF	285.71	285.78	284.01	284.63	70794.0
2019-08-15 05:30:00	SPY	ETF	284.56	284.56	283.14	283.8	97756.0
2019-08-15 06:00:00	SPY	ETF	283.76	283.77	282.4	282.46	104258.0
2019-08-15 06:30:00	SPY	ETF	282.46	282.84	281.63	282.79	302856.0
2019-08-15 07:00:00	SPY	ETF	282.75	285.68	282.71	285.62	642231.0
2019-08-15 07:30:00	SPY	ETF	285.65	286.35	284.19	285.7	1335543.0
2019-08-15 08:00:00	SPY	ETF	282.86	287.07	282.7301	284.98	1718770.0
2019-08-15 08:30:00	SPY	ETF	284.95	286.0	284.71	285.68	1517365.0
2019-08-15 09:00:00	SPY	ETF	285.64	285.94	284.46	284.9	1515875.0
2019-08-15 09:30:00	SPY	ETF	284.88	285.45	283.35	285.15	13494443.0
2019-08-15 10:00:00	SPY	ETF	285.16	285.64	284.52	284.52	6196306.0
2019-08-15 10:30:00	SPY	ETF	284.51	285.34	284.11	284.63	4446241.0
2019-08-15 11:00:00	SPY	ETF	284.64	284.64	283.34	284.43	5473661.0
2019-08-15 11:30:00	SPY	ETF	284.43	284.96	284.16	284.91	4290062.0
2019-08-15 12:00:00	SPY	ETF	284.91	285.47	284.63	284.6599	4271273.0
2019-08-15 12:30:00	SPY	ETF	284.645	285.44	284.24	284.52	3454779.0
2019-08-15 13:00:00	SPY	ETF	284.53	285.01	284.17	284.31	3873842.0
2019-08-15 13:30:00	SPY	ETF	284.3	284.52	282.39	282.68	6982397.0
2019-08-15 14:00:00	SPY	ETF	282.69	284.23	282.41	284.065	7630079.0
2019-08-15 14:30:00	SPY	ETF	284.08	284.34	283.57	284.16	4742008.0
2019-08-15 15:00:00	SPY	ETF	284.17	285.12	284.17	284.44	4795441.0
2019-08-15 15:30:00	SPY	ETF	284.43	285.43	284.33	284.69	12660910.0
2019-08-15 16:00:00	SPY	ETF	284.67	284.97	283.6118	284.85	8458133.0
2019-08-15 16:30:00	SPY	ETF	284.83	285.09	284.58	285.03	462329.0
2019-08-15 17:00:00	SPY	ETF	285.09	285.24	284.9	284.94	1482698.0
2019-08-15 17:30:00	SPY	ETF	284.95	285.09	284.78	284.87	198727.0
2019-08-15 18:00:00	SPY	ETF	284.9	285.6	284.9	285.55	199642.0
2019-08-15 18:30:00	SPY	ETF	285.55	285.55	285.37	285.47	11844.0
2019-08-15 19:00:00	SPY	ETF	285.47	285.55	285.42	285.46	17134.0
2019-08-15 19:30:00	SPY	ETF	285.46	285.55	285.16	285.29	44165.0
2019-08-15 04:00:00	QQQ	ETF	183.44	183.75	183.19	183.75	22993.0
2019-08-15 04:30:00	QQQ	ETF	183.69	184.0	183.6	183.6	21162.0
2019-08-15 05:00:00	QQQ	ETF	183.52	183.57	182.25	182.61	49430.0
2019-08-15 05:30:00	QQQ	ETF	182.47	182.49	181.35	181.73	64889.0
2019-08-15 06:00:00	QQQ	ETF	181.69	181.79	180.55	180.71	104312.0
2019-08-15 06:30:00	QQQ	ETF	180.54	180.99	180.02	180.99	120517.0
2019-08-15 07:00:00	QQQ	ETF	180.98	183.28	180.95	183.28	193719.0
2019-08-15 07:30:00	QQQ	ETF	183.26	183.87	182.19	183.41	412063.0
2019-08-15 08:00:00	QQQ	ETF	183.41	184.47	180.91	182.97	510005.0
2019-08-15 08:30:00	QQQ	ETF	183.03	183.9	182.85	183.69	332645.0
2019-08-15 09:00:00	QQQ	ETF	183.63	183.91	182.9	183.12	466579.0
2019-08-15 09:30:00	QQQ	ETF	183.11	183.59	181.78	183.13	6629989.0
2019-08-15 10:00:00	QQQ	ETF	183.12	183.4235	182.56	182.69	2682910.0
2019-08-15 10:30:00	QQQ	ETF	182.69	183.1	182.38	182.61	1770757.0
2019-08-15 11:00:00	QQQ	ETF	182.61	182.63	181.635	182.44	2296482.0
2019-08-15 11:30:00	QQQ	ETF	182.45	182.94	182.29	182.92	1425144.0
2019-08-15 12:00:00	QQQ	ETF	182.9098	183.35	182.61	182.63	1373233.0
2019-08-15 12:30:00	QQQ	ETF	182.63	182.87	182.34	182.6	1239111.0

> showing 50 of 18,674 rows — these rows as CSV

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