PREVIEW / etf_30min / 2020-10-23

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-10-23.parquet
  size:    539 KB
  rows:    19,615

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-10-23 04:00:00	SPY	ETF	345.42	345.88	345.42	345.57	9915.0
2020-10-23 04:30:00	SPY	ETF	345.52	345.53	345.22	345.22	2376.0
2020-10-23 05:00:00	SPY	ETF	345.26	345.83	345.15	345.79	9173.0
2020-10-23 05:30:00	SPY	ETF	345.9	345.92	345.43	345.43	11315.0
2020-10-23 06:00:00	SPY	ETF	345.48	345.6	345.24	345.34	21904.0
2020-10-23 06:30:00	SPY	ETF	345.44	346.0	345.44	345.74	14335.0
2020-10-23 07:00:00	SPY	ETF	345.72	345.8	345.48	345.56	62025.0
2020-10-23 07:30:00	SPY	ETF	345.64	346.12	345.63	345.88	49558.0
2020-10-23 08:00:00	SPY	ETF	345.54	346.12	344.1	345.99	83650.0
2020-10-23 08:30:00	SPY	ETF	345.97	346.18	345.9	346.01	92895.0
2020-10-23 09:00:00	SPY	ETF	346.0	346.09	345.76	345.93	200069.0
2020-10-23 09:30:00	SPY	ETF	345.93	345.99	344.83	345.35	4954963.0
2020-10-23 10:00:00	SPY	ETF	345.3392	345.3392	344.4	344.88	2986324.0
2020-10-23 10:30:00	SPY	ETF	344.89	345.27	344.42	344.71	3473870.0
2020-10-23 11:00:00	SPY	ETF	344.71	345.24	343.98	344.4899	2758137.0
2020-10-23 11:30:00	SPY	ETF	344.48	344.6	343.605	344.15	2431826.0
2020-10-23 12:00:00	SPY	ETF	344.145	344.45	343.13	343.62	3536783.0
2020-10-23 12:30:00	SPY	ETF	343.6286	344.025	343.18	343.41	1921987.0
2020-10-23 13:00:00	SPY	ETF	343.4	344.61	343.35	344.49	2612211.0
2020-10-23 13:30:00	SPY	ETF	344.48	344.69	344.25	344.48	1328677.0
2020-10-23 14:00:00	SPY	ETF	344.49	345.04	344.32	345.0299	1907599.0
2020-10-23 14:30:00	SPY	ETF	345.03	345.16	344.6519	344.74	1896452.0
2020-10-23 15:00:00	SPY	ETF	344.72	345.42	344.7	345.135	2272106.0
2020-10-23 15:30:00	SPY	ETF	345.14	345.77	344.98	345.76	8197386.0
2020-10-23 16:00:00	SPY	ETF	345.75	345.78	345.07	345.18	7141158.0
2020-10-23 16:30:00	SPY	ETF	345.2	345.6835	345.2	345.22	285274.0
2020-10-23 17:00:00	SPY	ETF	345.22	345.45	345.19	345.2	79324.0
2020-10-23 17:30:00	SPY	ETF	345.21	345.52	345.2	345.52	34722.0
2020-10-23 18:00:00	SPY	ETF	345.52	345.61	345.21	345.55	16518.0
2020-10-23 18:30:00	SPY	ETF	345.52	345.58	345.45	345.52	16078.0
2020-10-23 19:00:00	SPY	ETF	345.52	345.57	345.5	345.54	13749.0
2020-10-23 19:30:00	SPY	ETF	345.52	345.55	345.4	345.55	19363.0
2020-10-23 04:00:00	QQQ	ETF	284.68	284.83	284.53	284.66	11756.0
2020-10-23 04:30:00	QQQ	ETF	284.62	284.62	284.2	284.23	12300.0
2020-10-23 05:00:00	QQQ	ETF	284.12	284.6	284.02	284.59	5790.0
2020-10-23 05:30:00	QQQ	ETF	284.59	284.59	284.3	284.3	2118.0
2020-10-23 06:00:00	QQQ	ETF	284.36	284.41	283.86	283.86	18700.0
2020-10-23 06:30:00	QQQ	ETF	283.89	284.66	283.8	284.49	20431.0
2020-10-23 07:00:00	QQQ	ETF	284.48	284.76	284.33	284.58	39520.0
2020-10-23 07:30:00	QQQ	ETF	284.58	284.9	284.57	284.76	54963.0
2020-10-23 08:00:00	QQQ	ETF	284.39	285.19	284.0	285.05	64346.0
2020-10-23 08:30:00	QQQ	ETF	285.05	285.17	284.88	285.01	83788.0
2020-10-23 09:00:00	QQQ	ETF	284.95	284.98	284.72	284.88	101899.0
2020-10-23 09:30:00	QQQ	ETF	284.86	284.87	282.752	283.34	2531009.0
2020-10-23 10:00:00	QQQ	ETF	283.31	283.53	282.23	283.19	1699246.0
2020-10-23 10:30:00	QQQ	ETF	283.18	283.65	282.285	283.046	1679573.0
2020-10-23 11:00:00	QQQ	ETF	283.02	283.89	282.38	282.84	1485407.0
2020-10-23 11:30:00	QQQ	ETF	282.83	283.02	281.7818	282.54	1626732.0
2020-10-23 12:00:00	QQQ	ETF	282.5607	283.16	282.03	282.57	1421293.0
2020-10-23 12:30:00	QQQ	ETF	282.5528	283.35	282.3701	282.82	1019581.0

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

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