PREVIEW / etf_30min / 2019-06-12

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-06-12.parquet
  size:    480 KB
  rows:    16,759

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-06-12 04:00:00	SPY	ETF	288.4	288.64	288.15	288.23	5678.0
2019-06-12 04:30:00	SPY	ETF	288.28	288.48	288.19	288.21	10911.0
2019-06-12 05:00:00	SPY	ETF	288.05	288.31	288.04	288.21	5407.0
2019-06-12 05:30:00	SPY	ETF	288.29	288.29	287.97	287.98	12577.0
2019-06-12 06:00:00	SPY	ETF	288.1	288.13	287.86	288.13	5677.0
2019-06-12 06:30:00	SPY	ETF	288.18	288.45	288.18	288.45	9129.0
2019-06-12 07:00:00	SPY	ETF	288.46	288.57	288.15	288.22	89463.0
2019-06-12 07:30:00	SPY	ETF	288.28	288.36	288.09	288.12	54730.0
2019-06-12 08:00:00	SPY	ETF	288.51	288.9	288.05	288.32	114286.0
2019-06-12 08:30:00	SPY	ETF	288.32	288.64	288.3	288.31	399717.0
2019-06-12 09:00:00	SPY	ETF	288.34	288.69	288.34	288.64	362366.0
2019-06-12 09:30:00	SPY	ETF	288.64	289.26	288.41	288.84	6071528.0
2019-06-12 10:00:00	SPY	ETF	288.84	288.98	288.2	288.26	4569260.0
2019-06-12 10:30:00	SPY	ETF	288.26	288.84	288.04	288.32	3670586.0
2019-06-12 11:00:00	SPY	ETF	288.315	288.5	288.13	288.33	2152338.0
2019-06-12 11:30:00	SPY	ETF	288.33	288.54	287.83	287.845	2929214.0
2019-06-12 12:00:00	SPY	ETF	287.85	288.39	287.815	288.28	2910293.0
2019-06-12 12:30:00	SPY	ETF	288.28	288.58	288.16	288.425	2594356.0
2019-06-12 13:00:00	SPY	ETF	288.43	288.56	288.21	288.37	1880727.0
2019-06-12 13:30:00	SPY	ETF	288.38	288.425	288.115	288.39	2019105.0
2019-06-12 14:00:00	SPY	ETF	288.3941	288.43	288.01	288.16	1434811.0
2019-06-12 14:30:00	SPY	ETF	288.16	288.56	288.05	288.42	1916748.0
2019-06-12 15:00:00	SPY	ETF	288.42	288.47	288.2	288.21	1789997.0
2019-06-12 15:30:00	SPY	ETF	288.21	288.43	288.0401	288.36	5476919.0
2019-06-12 16:00:00	SPY	ETF	288.33	288.48	288.27	288.46	4656375.0
2019-06-12 16:30:00	SPY	ETF	288.46	288.54	288.39	288.43	773319.0
2019-06-12 17:00:00	SPY	ETF	288.42	288.53	288.36	288.38	85671.0
2019-06-12 17:30:00	SPY	ETF	288.44	288.44	288.39	288.42	14115.0
2019-06-12 18:00:00	SPY	ETF	288.47	288.63	288.39	288.51	54740.0
2019-06-12 18:30:00	SPY	ETF	288.45	288.76	288.43	288.71	21534.0
2019-06-12 19:00:00	SPY	ETF	288.75	288.76	288.74	288.74	5303.0
2019-06-12 19:30:00	SPY	ETF	288.76	288.89	288.67	288.83	29835.0
2019-06-12 04:00:00	QQQ	ETF	182.63	182.92	182.6	182.62	16229.0
2019-06-12 04:30:00	QQQ	ETF	182.6	182.68	182.55	182.55	1500.0
2019-06-12 05:00:00	QQQ	ETF	182.5	182.67	182.5	182.65	5500.0
2019-06-12 05:30:00	QQQ	ETF	182.66	182.66	182.36	182.41	17421.0
2019-06-12 06:00:00	QQQ	ETF	182.49	182.49	182.34	182.48	3100.0
2019-06-12 06:30:00	QQQ	ETF	182.54	182.74	182.54	182.72	19830.0
2019-06-12 07:00:00	QQQ	ETF	182.74	182.85	182.54	182.57	88008.0
2019-06-12 07:30:00	QQQ	ETF	182.6	182.68	182.51	182.52	30745.0
2019-06-12 08:00:00	QQQ	ETF	182.83	183.21	182.51	182.69	124098.0
2019-06-12 08:30:00	QQQ	ETF	182.69	182.95	182.6	182.7	130393.0
2019-06-12 09:00:00	QQQ	ETF	182.7	182.9	182.69	182.87	112700.0
2019-06-12 09:30:00	QQQ	ETF	182.88	183.28	182.47	182.995	3199820.0
2019-06-12 10:00:00	QQQ	ETF	183.0	183.11	182.3	182.3	2893318.0
2019-06-12 10:30:00	QQQ	ETF	182.3	182.89	182.07	182.4	3348120.0
2019-06-12 11:00:00	QQQ	ETF	182.4	182.665	182.31	182.51	1029345.0
2019-06-12 11:30:00	QQQ	ETF	182.51	182.6999	182.11	182.13	1657908.0
2019-06-12 12:00:00	QQQ	ETF	182.13	182.54	182.0	182.44	1629484.0
2019-06-12 12:30:00	QQQ	ETF	182.44	182.63	182.34	182.52	749616.0

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

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