PREVIEW / etf_30min / 2019-06-18

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-06-18.parquet
  size:    511 KB
  rows:    17,898

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-18 04:00:00	SPY	ETF	289.22	290.6	289.14	290.36	16147.0
2019-06-18 04:30:00	SPY	ETF	290.45	290.7	290.33	290.33	11100.0
2019-06-18 05:00:00	SPY	ETF	290.48	290.56	290.38	290.43	13225.0
2019-06-18 05:30:00	SPY	ETF	290.41	290.41	290.23	290.33	7314.0
2019-06-18 06:00:00	SPY	ETF	290.36	290.64	290.33	290.64	11178.0
2019-06-18 06:30:00	SPY	ETF	290.68	291.18	290.6	291.07	80530.0
2019-06-18 07:00:00	SPY	ETF	291.05	291.08	290.93	290.99	134256.0
2019-06-18 07:30:00	SPY	ETF	290.98	291.47	290.93	291.37	276379.0
2019-06-18 08:00:00	SPY	ETF	291.35	291.48	289.0	291.44	377500.0
2019-06-18 08:30:00	SPY	ETF	291.45	291.55	291.23	291.34	553564.0
2019-06-18 09:00:00	SPY	ETF	291.32	291.48	291.25	291.36	537461.0
2019-06-18 09:30:00	SPY	ETF	291.39	293.2	290.99	292.75	15356572.0
2019-06-18 10:00:00	SPY	ETF	292.76	293.18	292.57	292.85	7585409.0
2019-06-18 10:30:00	SPY	ETF	292.85	293.49	292.85	293.34	4839118.0
2019-06-18 11:00:00	SPY	ETF	293.34	293.57	292.5	292.96	7454695.0
2019-06-18 11:30:00	SPY	ETF	292.955	293.02	292.32	292.325	4395640.0
2019-06-18 12:00:00	SPY	ETF	292.32	292.64	292.195	292.54	3953487.0
2019-06-18 12:30:00	SPY	ETF	292.54	292.72	292.46	292.52	2881989.0
2019-06-18 13:00:00	SPY	ETF	292.51	292.51	291.89	292.11	3136913.0
2019-06-18 13:30:00	SPY	ETF	292.11	292.45	292.09	292.43	3186162.0
2019-06-18 14:00:00	SPY	ETF	292.43	292.79	292.4	292.725	3460644.0
2019-06-18 14:30:00	SPY	ETF	292.725	292.82	292.42	292.48	3950478.0
2019-06-18 15:00:00	SPY	ETF	292.485	292.59	292.27	292.47	3572365.0
2019-06-18 15:30:00	SPY	ETF	292.48	292.51	291.93	292.29	11540259.0
2019-06-18 16:00:00	SPY	ETF	292.3	292.67	292.2314	292.65	5232134.0
2019-06-18 16:30:00	SPY	ETF	292.65	292.7	292.53	292.53	195961.0
2019-06-18 17:00:00	SPY	ETF	292.59	292.61	292.45	292.61	22374.0
2019-06-18 17:30:00	SPY	ETF	292.4	292.61	292.4	292.52	55159.0
2019-06-18 18:00:00	SPY	ETF	292.52	292.57	292.36	292.57	84619.0
2019-06-18 18:30:00	SPY	ETF	292.54	292.69	292.5	292.65	71878.0
2019-06-18 19:00:00	SPY	ETF	292.65	292.74	292.63	292.69	74509.0
2019-06-18 19:30:00	SPY	ETF	292.69	292.9	292.66	292.82	57390.0
2019-06-18 04:00:00	QQQ	ETF	183.57	184.95	183.54	184.8	27886.0
2019-06-18 04:30:00	QQQ	ETF	184.85	185.13	184.68	184.76	15394.0
2019-06-18 05:00:00	QQQ	ETF	184.83	184.94	184.75	184.86	14939.0
2019-06-18 05:30:00	QQQ	ETF	184.86	184.89	184.75	184.81	23950.0
2019-06-18 06:00:00	QQQ	ETF	184.87	185.13	184.76	185.1	17440.0
2019-06-18 06:30:00	QQQ	ETF	185.1	185.73	185.06	185.59	60477.0
2019-06-18 07:00:00	QQQ	ETF	185.56	185.61	185.33	185.42	171156.0
2019-06-18 07:30:00	QQQ	ETF	185.41	185.79	185.36	185.74	210204.0
2019-06-18 08:00:00	QQQ	ETF	185.49	185.94	183.54	185.89	173951.0
2019-06-18 08:30:00	QQQ	ETF	185.91	186.0	185.68	185.85	239957.0
2019-06-18 09:00:00	QQQ	ETF	185.85	185.97	185.75	185.85	316623.0
2019-06-18 09:30:00	QQQ	ETF	185.85	187.42	185.4291	187.06	9066928.0
2019-06-18 10:00:00	QQQ	ETF	187.06	187.49	187.0	187.265	4109771.0
2019-06-18 10:30:00	QQQ	ETF	187.26	187.72	187.2533	187.5415	2292259.0
2019-06-18 11:00:00	QQQ	ETF	187.545	187.69	186.98	187.23	2502489.0
2019-06-18 11:30:00	QQQ	ETF	187.23	187.35	186.64	186.67	1674459.0
2019-06-18 12:00:00	QQQ	ETF	186.66	186.95	186.55	186.68	1645328.0
2019-06-18 12:30:00	QQQ	ETF	186.68	186.95	186.6449	186.72	1493724.0

> showing 50 of 17,898 rows — these rows as CSV

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