PREVIEW / etf_30min / 2019-08-06

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-08-06.parquet
  size:    536 KB
  rows:    18,680

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-06 04:00:00	SPY	ETF	283.68	285.15	283.17	285.02	94152.0
2019-08-06 04:30:00	SPY	ETF	285.02	285.19	284.8	285.07	37855.0
2019-08-06 05:00:00	SPY	ETF	284.94	285.62	284.94	285.49	31863.0
2019-08-06 05:30:00	SPY	ETF	285.36	285.78	285.24	285.4	113196.0
2019-08-06 06:00:00	SPY	ETF	285.24	285.24	284.9	285.07	164074.0
2019-08-06 06:30:00	SPY	ETF	285.05	285.42	284.92	285.09	123442.0
2019-08-06 07:00:00	SPY	ETF	285.11	285.5	284.87	285.5	474918.0
2019-08-06 07:30:00	SPY	ETF	285.46	286.15	285.31	285.43	304599.0
2019-08-06 08:00:00	SPY	ETF	281.09	286.06	279.3075	285.02	1239289.0
2019-08-06 08:30:00	SPY	ETF	285.01	285.5	284.91	285.05	841232.0
2019-08-06 09:00:00	SPY	ETF	285.05	285.95	283.75	285.91	1614002.0
2019-08-06 09:30:00	SPY	ETF	285.91	286.93	285.61	286.14	13633038.0
2019-08-06 10:00:00	SPY	ETF	286.145	286.75	284.7	285.37	10118249.0
2019-08-06 10:30:00	SPY	ETF	285.37	286.46	285.19	285.68	5956683.0
2019-08-06 11:00:00	SPY	ETF	285.7	285.76	284.28	285.06	9675226.0
2019-08-06 11:30:00	SPY	ETF	285.07	285.58	284.3	285.53	5582021.0
2019-08-06 12:00:00	SPY	ETF	285.54	285.98	284.92	284.98	5190040.0
2019-08-06 12:30:00	SPY	ETF	284.97	285.46	284.82	285.1	4718918.0
2019-08-06 13:00:00	SPY	ETF	285.12	286.38	285.12	286.12	5246304.0
2019-08-06 13:30:00	SPY	ETF	286.12	286.72	285.99	286.6	4537152.0
2019-08-06 14:00:00	SPY	ETF	286.58	287.595	286.0	287.53	5959074.0
2019-08-06 14:30:00	SPY	ETF	287.53	288.0	286.97	287.0	6802435.0
2019-08-06 15:00:00	SPY	ETF	287.0	287.65	286.78	287.195	5671449.0
2019-08-06 15:30:00	SPY	ETF	287.19	288.04	286.75	287.77	15101380.0
2019-08-06 16:00:00	SPY	ETF	287.78	287.99	287.18	287.46	12399383.0
2019-08-06 16:30:00	SPY	ETF	287.45	287.8	287.2	287.23	664637.0
2019-08-06 17:00:00	SPY	ETF	287.25	287.7526	284.0594	287.05	231191.0
2019-08-06 17:30:00	SPY	ETF	287.07	287.28	286.96	286.96	759604.0
2019-08-06 18:00:00	SPY	ETF	287.02	287.29	287.02	287.26	37902.0
2019-08-06 18:30:00	SPY	ETF	287.26	287.26	286.97	286.97	45966.0
2019-08-06 19:00:00	SPY	ETF	287.0	287.0	286.43	286.43	57057.0
2019-08-06 19:30:00	SPY	ETF	286.55	286.64	286.26	286.64	112398.0
2019-08-06 04:00:00	QQQ	ETF	180.64	182.5	180.31	181.9	52376.0
2019-08-06 04:30:00	QQQ	ETF	181.98	182.0	181.63	181.95	48659.0
2019-08-06 05:00:00	QQQ	ETF	181.8	182.24	181.73	182.09	20306.0
2019-08-06 05:30:00	QQQ	ETF	182.14	182.24	181.73	181.79	28459.0
2019-08-06 06:00:00	QQQ	ETF	181.83	181.83	181.44	181.6	33424.0
2019-08-06 06:30:00	QQQ	ETF	181.61	181.95	181.47	181.63	50821.0
2019-08-06 07:00:00	QQQ	ETF	181.63	182.01	181.4	181.95	150527.0
2019-08-06 07:30:00	QQQ	ETF	181.99	182.44	181.82	181.96	325896.0
2019-08-06 08:00:00	QQQ	ETF	181.43	182.41	180.02	181.63	345691.0
2019-08-06 08:30:00	QQQ	ETF	181.6	182.0	181.58	181.75	310113.0
2019-08-06 09:00:00	QQQ	ETF	181.75	182.48	181.66	182.41	471310.0
2019-08-06 09:30:00	QQQ	ETF	182.4	183.29	182.27	182.99	6640888.0
2019-08-06 10:00:00	QQQ	ETF	182.96	183.46	181.71	182.17	3674386.0
2019-08-06 10:30:00	QQQ	ETF	182.1963	182.97	182.04	182.4	1766955.0
2019-08-06 11:00:00	QQQ	ETF	182.41	182.465	181.37	181.83	2479934.0
2019-08-06 11:30:00	QQQ	ETF	181.835	182.08	181.07	182.06	2472279.0
2019-08-06 12:00:00	QQQ	ETF	182.06	182.41	181.5301	181.57	1514136.0
2019-08-06 12:30:00	QQQ	ETF	181.57	181.99	181.46	181.66	1266922.0

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

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