PREVIEW / etf_30min / 2019-06-06

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-06-06.parquet
  size:    496 KB
  rows:    17,269

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-06 04:00:00	SPY	ETF	283.71	283.86	283.68	283.76	15884.0
2019-06-06 04:30:00	SPY	ETF	283.81	283.85	283.68	283.81	16442.0
2019-06-06 05:00:00	SPY	ETF	283.84	283.9	283.67	283.82	9368.0
2019-06-06 05:30:00	SPY	ETF	283.77	284.01	283.7	283.73	34760.0
2019-06-06 06:00:00	SPY	ETF	283.74	283.96	283.68	283.95	10439.0
2019-06-06 06:30:00	SPY	ETF	283.9	283.92	283.78	283.78	14362.0
2019-06-06 07:00:00	SPY	ETF	283.78	283.97	283.73	283.92	147517.0
2019-06-06 07:30:00	SPY	ETF	283.91	283.95	283.54	283.95	132596.0
2019-06-06 08:00:00	SPY	ETF	283.91	283.94	282.53	283.8	83001.0
2019-06-06 08:30:00	SPY	ETF	283.74	283.89	282.99	283.1	429958.0
2019-06-06 09:00:00	SPY	ETF	283.09	283.4	283.03	283.27	206562.0
2019-06-06 09:30:00	SPY	ETF	283.29	283.69	282.76	282.86	5853289.0
2019-06-06 10:00:00	SPY	ETF	282.855	283.28	282.62	282.63	3262503.0
2019-06-06 10:30:00	SPY	ETF	282.64	283.57	282.57	283.28	3614272.0
2019-06-06 11:00:00	SPY	ETF	283.2711	283.83	283.08	283.75	3115990.0
2019-06-06 11:30:00	SPY	ETF	283.76	283.89	282.98	283.19	4133275.0
2019-06-06 12:00:00	SPY	ETF	283.1901	283.53	283.105	283.4	2251304.0
2019-06-06 12:30:00	SPY	ETF	283.39	283.71	283.32	283.59	1944332.0
2019-06-06 13:00:00	SPY	ETF	283.6	283.7399	283.45	283.66	1527539.0
2019-06-06 13:30:00	SPY	ETF	283.65	283.78	283.57	283.7338	1343460.0
2019-06-06 14:00:00	SPY	ETF	283.73	283.92	283.52	283.75	2520909.0
2019-06-06 14:30:00	SPY	ETF	283.74	284.64	283.715	284.19	6733874.0
2019-06-06 15:00:00	SPY	ETF	284.2	285.08	284.11	284.9999	4603736.0
2019-06-06 15:30:00	SPY	ETF	284.99	285.55	284.51	284.74	14210154.0
2019-06-06 16:00:00	SPY	ETF	284.74	284.94	283.25	284.82	7569181.0
2019-06-06 16:30:00	SPY	ETF	284.82	284.85	284.0	284.28	1238486.0
2019-06-06 17:00:00	SPY	ETF	284.3	284.8	284.11	284.27	74496.0
2019-06-06 17:30:00	SPY	ETF	284.27	284.27	284.11	284.19	30338.0
2019-06-06 18:00:00	SPY	ETF	284.17	284.8	284.08	284.23	53592.0
2019-06-06 18:30:00	SPY	ETF	284.18	284.32	284.11	284.19	8525.0
2019-06-06 19:00:00	SPY	ETF	284.21	284.7	284.2	284.7	19071.0
2019-06-06 19:30:00	SPY	ETF	284.61	284.8	284.55	284.71	32073.0
2019-06-06 04:00:00	QQQ	ETF	176.86	176.98	176.79	176.83	12302.0
2019-06-06 04:30:00	QQQ	ETF	176.91	176.97	176.85	176.95	51910.0
2019-06-06 05:00:00	QQQ	ETF	176.9	177.08	176.82	177.02	24820.0
2019-06-06 05:30:00	QQQ	ETF	176.96	177.17	176.92	176.92	27360.0
2019-06-06 06:00:00	QQQ	ETF	176.89	177.08	176.88	177.05	30262.0
2019-06-06 06:30:00	QQQ	ETF	177.08	177.08	176.94	176.98	9231.0
2019-06-06 07:00:00	QQQ	ETF	176.93	177.07	176.85	177.01	103742.0
2019-06-06 07:30:00	QQQ	ETF	176.99	177.05	176.68	176.99	86234.0
2019-06-06 08:00:00	QQQ	ETF	176.93	177.0699	176.02	176.84	69973.0
2019-06-06 08:30:00	QQQ	ETF	176.84	176.93	176.16	176.26	287236.0
2019-06-06 09:00:00	QQQ	ETF	176.31	176.54	176.22	176.49	129814.0
2019-06-06 09:30:00	QQQ	ETF	176.52	176.78	175.88	175.91	3022153.0
2019-06-06 10:00:00	QQQ	ETF	175.91	176.265	175.8456	175.8637	1561599.0
2019-06-06 10:30:00	QQQ	ETF	175.89	176.56	175.73	176.28	2025085.0
2019-06-06 11:00:00	QQQ	ETF	176.28	176.82	176.15	176.79	1309098.0
2019-06-06 11:30:00	QQQ	ETF	176.8	176.93	176.26	176.4	1841814.0
2019-06-06 12:00:00	QQQ	ETF	176.4	176.555	176.28	176.43	806271.0
2019-06-06 12:30:00	QQQ	ETF	176.41	176.775	176.39	176.6	708918.0

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

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