PREVIEW / etf_30min / 2020-01-24

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-01-24.parquet
  size:    559 KB
  rows:    19,505

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-24 04:00:00	SPY	ETF	332.75	332.92	332.74	332.79	21963.0
2020-01-24 04:30:00	SPY	ETF	332.78	332.81	332.56	332.58	8147.0
2020-01-24 05:00:00	SPY	ETF	332.53	332.64	332.48	332.63	4064.0
2020-01-24 05:30:00	SPY	ETF	332.66	332.66	332.42	332.46	12992.0
2020-01-24 06:00:00	SPY	ETF	332.67	332.68	332.52	332.52	1400.0
2020-01-24 06:30:00	SPY	ETF	332.57	332.74	332.57	332.74	5120.0
2020-01-24 07:00:00	SPY	ETF	332.7	332.75	332.46	332.46	37243.0
2020-01-24 07:30:00	SPY	ETF	332.48	332.65	332.48	332.62	31018.0
2020-01-24 08:00:00	SPY	ETF	332.53	332.94	332.17	332.56	92035.0
2020-01-24 08:30:00	SPY	ETF	332.54	332.63	332.42	332.5	125089.0
2020-01-24 09:00:00	SPY	ETF	332.45	332.62	332.36	332.44	197596.0
2020-01-24 09:30:00	SPY	ETF	332.44	332.53	331.75	332.21	4147099.0
2020-01-24 10:00:00	SPY	ETF	332.22	332.2332	330.97	330.98	4394737.0
2020-01-24 10:30:00	SPY	ETF	330.98	331.33	330.83	331.16	4233741.0
2020-01-24 11:00:00	SPY	ETF	331.165	331.545	330.37	330.71	4644550.0
2020-01-24 11:30:00	SPY	ETF	330.7	330.8	329.94	329.965	4289506.0
2020-01-24 12:00:00	SPY	ETF	329.96	329.97	328.69	329.14	7339454.0
2020-01-24 12:30:00	SPY	ETF	329.16	331.97	329.03	329.7875	4787725.0
2020-01-24 13:00:00	SPY	ETF	329.79	329.8	328.88	328.9	2975041.0
2020-01-24 13:30:00	SPY	ETF	328.895	331.7683	328.0301	328.46	7459128.0
2020-01-24 14:00:00	SPY	ETF	328.47	328.54	327.36	327.5654	6993379.0
2020-01-24 14:30:00	SPY	ETF	327.55	328.63	327.48	328.61	5078805.0
2020-01-24 15:00:00	SPY	ETF	328.61	329.26	328.43	328.91	6535922.0
2020-01-24 15:30:00	SPY	ETF	328.92	328.98	327.84	328.75	12402219.0
2020-01-24 16:00:00	SPY	ETF	328.74	331.7683	328.55	328.59	10080509.0
2020-01-24 16:30:00	SPY	ETF	328.61	328.77	328.4	328.41	332531.0
2020-01-24 17:00:00	SPY	ETF	328.39	328.77	328.39	328.47	211649.0
2020-01-24 17:30:00	SPY	ETF	328.48	328.54	328.15	328.31	106288.0
2020-01-24 18:00:00	SPY	ETF	328.29	328.58	328.2	328.55	53777.0
2020-01-24 18:30:00	SPY	ETF	328.55	328.58	328.36	328.4	22886.0
2020-01-24 19:00:00	SPY	ETF	328.37	328.44	328.31	328.39	11187.0
2020-01-24 19:30:00	SPY	ETF	328.34	328.4	328.26	328.26	16096.0
2020-01-24 04:00:00	QQQ	ETF	225.87	225.93	225.85	225.9	3024.0
2020-01-24 04:30:00	QQQ	ETF	225.89	225.93	225.79	225.8	4200.0
2020-01-24 05:00:00	QQQ	ETF	225.75	225.8	225.7	225.76	13362.0
2020-01-24 05:30:00	QQQ	ETF	225.71	225.74	225.65	225.68	1595.0
2020-01-24 06:00:00	QQQ	ETF	225.75	225.79	225.72	225.74	2600.0
2020-01-24 06:30:00	QQQ	ETF	225.78	225.86	225.74	225.86	9484.0
2020-01-24 07:00:00	QQQ	ETF	225.86	225.86	225.62	225.67	70222.0
2020-01-24 07:30:00	QQQ	ETF	225.74	225.75	225.63	225.69	37138.0
2020-01-24 08:00:00	QQQ	ETF	225.8099	225.99	225.51	225.66	44616.0
2020-01-24 08:30:00	QQQ	ETF	225.67	225.7	225.59	225.6699	48216.0
2020-01-24 09:00:00	QQQ	ETF	225.65	225.76	225.59	225.63	278207.0
2020-01-24 09:30:00	QQQ	ETF	225.62	225.88	225.23	225.55	2641499.0
2020-01-24 10:00:00	QQQ	ETF	225.55	225.55	224.6453	224.66	1846538.0
2020-01-24 10:30:00	QQQ	ETF	224.66	225.02	224.56	224.92	1697454.0
2020-01-24 11:00:00	QQQ	ETF	224.93	225.23	224.34	224.575	1660430.0
2020-01-24 11:30:00	QQQ	ETF	224.57	224.65	224.01	224.02	1563693.0
2020-01-24 12:00:00	QQQ	ETF	224.01	224.04	222.94	223.28	2584710.0
2020-01-24 12:30:00	QQQ	ETF	223.3	223.86	223.1701	223.82	2164990.0

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

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