PREVIEW / etf_30min / 2020-01-03

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-01-03.parquet
  size:    561 KB
  rows:    19,891

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
2020-01-03 04:00:00	SPY	ETF	321.82	321.82	321.25	321.38	38828.0
2020-01-03 04:30:00	SPY	ETF	321.5	321.52	321.14	321.39	9014.0
2020-01-03 05:00:00	SPY	ETF	321.42	321.6	321.31	321.4	7184.0
2020-01-03 05:30:00	SPY	ETF	321.37	321.37	319.69	320.07	63675.0
2020-01-03 06:00:00	SPY	ETF	320.15	320.86	320.06	320.74	48916.0
2020-01-03 06:30:00	SPY	ETF	320.7	320.77	320.43	320.55	136811.0
2020-01-03 07:00:00	SPY	ETF	320.53	321.5	320.45	321.33	596982.0
2020-01-03 07:30:00	SPY	ETF	321.32	321.5	321.29	321.48	211193.0
2020-01-03 08:00:00	SPY	ETF	321.32	322.75	320.5	322.14	510314.0
2020-01-03 08:30:00	SPY	ETF	322.18	322.18	321.75	321.8	453340.0
2020-01-03 09:00:00	SPY	ETF	321.77	321.98	321.06	321.13	887697.0
2020-01-03 09:30:00	SPY	ETF	321.16	322.95	321.1	322.745	9948658.0
2020-01-03 10:00:00	SPY	ETF	322.61	322.88	322.03	322.77	6273857.0
2020-01-03 10:30:00	SPY	ETF	322.78	323.1	322.4	322.5	4308576.0
2020-01-03 11:00:00	SPY	ETF	322.5	322.745	322.12	322.63	2126496.0
2020-01-03 11:30:00	SPY	ETF	322.64	323.23	322.57	323.1378	2776923.0
2020-01-03 12:00:00	SPY	ETF	323.14	323.59	323.12	323.29	2862073.0
2020-01-03 12:30:00	SPY	ETF	323.3	323.64	323.26	323.415	2106027.0
2020-01-03 13:00:00	SPY	ETF	323.42	323.55	323.2	323.39	2376214.0
2020-01-03 13:30:00	SPY	ETF	323.39	323.4499	322.32	322.94	5320386.0
2020-01-03 14:00:00	SPY	ETF	322.94	323.09	322.57	322.86	2501475.0
2020-01-03 14:30:00	SPY	ETF	322.8523	323.31	322.76	323.25	1999588.0
2020-01-03 15:00:00	SPY	ETF	323.25	323.55	322.79	322.8446	4574529.0
2020-01-03 15:30:00	SPY	ETF	322.84	323.08	322.42	322.44	11234007.0
2020-01-03 16:00:00	SPY	ETF	322.44	324.8065	322.38	322.48	10956764.0
2020-01-03 16:30:00	SPY	ETF	322.48	322.57	322.41	322.57	756997.0
2020-01-03 17:00:00	SPY	ETF	322.57	322.66	322.41	322.63	2048263.0
2020-01-03 17:30:00	SPY	ETF	322.6	322.69	322.6	322.66	18581.0
2020-01-03 18:00:00	SPY	ETF	322.66	322.79	322.61	322.71	35600.0
2020-01-03 18:30:00	SPY	ETF	322.69	322.83	322.65	322.65	7545.0
2020-01-03 19:00:00	SPY	ETF	322.69	322.8	322.67	322.75	12160.0
2020-01-03 19:30:00	SPY	ETF	322.67	322.71	322.55	322.65	16829.0
2020-01-03 04:00:00	QQQ	ETF	213.87	213.88	213.36	213.43	64333.0
2020-01-03 04:30:00	QQQ	ETF	213.48	213.48	213.1	213.41	30902.0
2020-01-03 05:00:00	QQQ	ETF	213.41	213.59	213.31	213.37	36861.0
2020-01-03 05:30:00	QQQ	ETF	213.36	213.39	212.44	212.63	62790.0
2020-01-03 06:00:00	QQQ	ETF	212.65	213.11	212.6	212.99	35853.0
2020-01-03 06:30:00	QQQ	ETF	213.01	213.09	212.75	212.97	71182.0
2020-01-03 07:00:00	QQQ	ETF	212.96	213.64	212.91	213.37	155716.0
2020-01-03 07:30:00	QQQ	ETF	213.38	213.49	213.23	213.46	127698.0
2020-01-03 08:00:00	QQQ	ETF	213.42	214.67	212.96	214.14	242185.0
2020-01-03 08:30:00	QQQ	ETF	214.1	214.11	213.71	213.78	368997.0
2020-01-03 09:00:00	QQQ	ETF	213.78	213.93	213.21	213.3	333493.0
2020-01-03 09:30:00	QQQ	ETF	213.3	214.95	213.28	214.61	4057707.0
2020-01-03 10:00:00	QQQ	ETF	214.57	214.79	214.1	214.675	2470515.0
2020-01-03 10:30:00	QQQ	ETF	214.67	214.88	214.37	214.4265	1202705.0
2020-01-03 11:00:00	QQQ	ETF	214.44	214.5799	214.1154	214.495	967742.0
2020-01-03 11:30:00	QQQ	ETF	214.5	214.89	214.45	214.81	744216.0
2020-01-03 12:00:00	QQQ	ETF	214.81	215.255	214.8	215.05	1126595.0
2020-01-03 12:30:00	QQQ	ETF	215.05	215.47	215.0264	215.2699	913682.0

> showing 50 of 19,891 rows — these rows as CSV

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