PREVIEW / etf_30min / 2019-11-01

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-11-01.parquet
  size:    517 KB
  rows:    18,008

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-11-01 04:00:00	SPY	ETF	303.82	304.05	303.82	303.85	5715.0
2019-11-01 04:30:00	SPY	ETF	303.76	303.86	303.76	303.86	1550.0
2019-11-01 05:00:00	SPY	ETF	303.9	303.9	303.81	303.9	3200.0
2019-11-01 05:30:00	SPY	ETF	303.9	303.95	303.85	303.85	3810.0
2019-11-01 06:00:00	SPY	ETF	303.92	303.96	303.87	303.92	4957.0
2019-11-01 06:30:00	SPY	ETF	303.93	304.03	303.93	303.97	39262.0
2019-11-01 07:00:00	SPY	ETF	303.97	303.97	303.67	303.69	19087.0
2019-11-01 07:30:00	SPY	ETF	303.7	304.01	303.54	303.61	44107.0
2019-11-01 08:00:00	SPY	ETF	303.8801	304.13	303.33	303.69	107252.0
2019-11-01 08:30:00	SPY	ETF	303.68	304.68	303.68	304.58	931105.0
2019-11-01 09:00:00	SPY	ETF	304.62	304.98	304.5	304.9	397381.0
2019-11-01 09:30:00	SPY	ETF	304.92	305.39	304.74	305.23	5697315.0
2019-11-01 10:00:00	SPY	ETF	305.24	305.89	304.79	305.5851	6984001.0
2019-11-01 10:30:00	SPY	ETF	305.585	305.7	305.41	305.63	3037304.0
2019-11-01 11:00:00	SPY	ETF	305.63	305.68	305.35	305.445	5948305.0
2019-11-01 11:30:00	SPY	ETF	305.445	305.62	305.4	305.53	3072761.0
2019-11-01 12:00:00	SPY	ETF	305.53	305.545	305.02	305.36	3287289.0
2019-11-01 12:30:00	SPY	ETF	305.36	305.53	305.23	305.28	2560019.0
2019-11-01 13:00:00	SPY	ETF	305.28	305.72	305.24	305.67	3842945.0
2019-11-01 13:30:00	SPY	ETF	305.67	306.01	305.65	305.85	3621232.0
2019-11-01 14:00:00	SPY	ETF	305.85	305.91	305.6	305.79	3536108.0
2019-11-01 14:30:00	SPY	ETF	305.795	305.88	305.65	305.785	2158810.0
2019-11-01 15:00:00	SPY	ETF	305.785	305.9	305.53	305.75	3547188.0
2019-11-01 15:30:00	SPY	ETF	305.745	306.19	305.58	306.18	11502223.0
2019-11-01 16:00:00	SPY	ETF	306.18	306.19	305.7505	306.02	8046162.0
2019-11-01 16:30:00	SPY	ETF	306.03	306.1631	305.96	306.01	480057.0
2019-11-01 17:00:00	SPY	ETF	306.01	306.05	305.94	305.99	406203.0
2019-11-01 17:30:00	SPY	ETF	306.01	306.14	305.98	306.13	66101.0
2019-11-01 18:00:00	SPY	ETF	306.13	306.15	306.08	306.14	12132.0
2019-11-01 18:30:00	SPY	ETF	306.14	306.17	306.11	306.17	5060.0
2019-11-01 19:00:00	SPY	ETF	306.14	306.19	306.0	306.01	19400.0
2019-11-01 19:30:00	SPY	ETF	306.06	306.09	306.03	306.07	8073.0
2019-11-01 04:00:00	QQQ	ETF	197.45	197.7	197.45	197.5	16826.0
2019-11-01 04:30:00	QQQ	ETF	197.46	197.51	197.42	197.51	1588.0
2019-11-01 05:00:00	QQQ	ETF	197.54	197.54	197.53	197.54	800.0
2019-11-01 05:30:00	QQQ	ETF	197.59	197.6	197.5	197.5	10850.0
2019-11-01 06:00:00	QQQ	ETF	197.55	197.57	197.51	197.51	2450.0
2019-11-01 06:30:00	QQQ	ETF	197.59	197.6	197.59	197.6	995.0
2019-11-01 07:00:00	QQQ	ETF	197.59	197.59	197.38	197.38	16842.0
2019-11-01 07:30:00	QQQ	ETF	197.4	197.6	197.22	197.23	41240.0
2019-11-01 08:00:00	QQQ	ETF	197.55	197.89	197.17	197.26	34194.0
2019-11-01 08:30:00	QQQ	ETF	197.4	197.99	197.39	197.88	330547.0
2019-11-01 09:00:00	QQQ	ETF	197.89	198.17	197.86	197.99	114183.0
2019-11-01 09:30:00	QQQ	ETF	197.94	198.42	197.7	198.23	2430561.0
2019-11-01 10:00:00	QQQ	ETF	198.22	198.77	197.93	198.53	2704819.0
2019-11-01 10:30:00	QQQ	ETF	198.53	198.61	198.27	198.45	933617.0
2019-11-01 11:00:00	QQQ	ETF	198.45	198.46	198.17	198.22	639319.0
2019-11-01 11:30:00	QQQ	ETF	198.22	198.385	198.175	198.255	551500.0
2019-11-01 12:00:00	QQQ	ETF	198.265	198.27	197.63	197.975	1298957.0
2019-11-01 12:30:00	QQQ	ETF	197.98	198.015	197.8	197.83	488862.0

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

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