PREVIEW / etf_30min / 2020-06-16

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-06-16.parquet
  size:    567 KB
  rows:    21,640

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-06-16 04:00:00	SPY	ETF	310.17	310.6	309.5	310.59	134405.0
2020-06-16 04:30:00	SPY	ETF	310.49	311.18	310.37	311.06	73378.0
2020-06-16 05:00:00	SPY	ETF	311.21	311.39	310.81	311.13	24619.0
2020-06-16 05:30:00	SPY	ETF	311.18	311.29	310.68	311.1	31697.0
2020-06-16 06:00:00	SPY	ETF	311.2	311.99	310.88	311.99	81514.0
2020-06-16 06:30:00	SPY	ETF	311.99	312.1	311.51	311.69	278682.0
2020-06-16 07:00:00	SPY	ETF	311.75	311.81	311.1	311.5	494639.0
2020-06-16 07:30:00	SPY	ETF	311.5	312.1	311.2	312.05	359277.0
2020-06-16 08:00:00	SPY	ETF	312.8	313.78	310.36	313.55	1224413.0
2020-06-16 08:30:00	SPY	ETF	313.67	316.96	313.63	316.26	2950309.0
2020-06-16 09:00:00	SPY	ETF	316.26	316.44	315.36	315.5	1480549.0
2020-06-16 09:30:00	SPY	ETF	315.48	315.56	313.77	314.54	12997035.0
2020-06-16 10:00:00	SPY	ETF	314.54	315.54	314.18	315.37	7576823.0
2020-06-16 10:30:00	SPY	ETF	315.4	315.64	309.06	309.43	17077192.0
2020-06-16 11:00:00	SPY	ETF	309.44	312.83	307.67	312.55	19365012.0
2020-06-16 11:30:00	SPY	ETF	312.55	313.7	311.74	312.26	8683550.0
2020-06-16 12:00:00	SPY	ETF	312.27	312.8	311.17	312.65	6040595.0
2020-06-16 12:30:00	SPY	ETF	312.64	314.18	312.59	313.48	6245824.0
2020-06-16 13:00:00	SPY	ETF	313.48	314.94	313.23	313.7	4081367.0
2020-06-16 13:30:00	SPY	ETF	313.69	313.87	312.14	312.695	3615139.0
2020-06-16 14:00:00	SPY	ETF	312.7	314.37	312.21	313.34	7494146.0
2020-06-16 14:30:00	SPY	ETF	313.36	314.21	312.74	313.07	4699639.0
2020-06-16 15:00:00	SPY	ETF	313.07	313.32	310.61	312.075	7916610.0
2020-06-16 15:30:00	SPY	ETF	312.08	313.03	311.185	312.93	16114922.0
2020-06-16 16:00:00	SPY	ETF	312.92	313.31	312.49	313.0	6752178.0
2020-06-16 16:30:00	SPY	ETF	313.0	313.05	312.82	312.95	754052.0
2020-06-16 17:00:00	SPY	ETF	312.91	312.99	312.5	312.5	154536.0
2020-06-16 17:30:00	SPY	ETF	312.53	312.96	312.43	312.61	49855.0
2020-06-16 18:00:00	SPY	ETF	312.56	312.69	311.321	312.26	195005.0
2020-06-16 18:30:00	SPY	ETF	312.3	312.87	312.11	312.87	80738.0
2020-06-16 19:00:00	SPY	ETF	312.79	313.59	312.79	313.38	145120.0
2020-06-16 19:30:00	SPY	ETF	313.35	313.97	313.26	313.85	142080.0
2020-06-16 04:00:00	QQQ	ETF	241.02	241.5	240.78	241.44	26460.0
2020-06-16 04:30:00	QQQ	ETF	241.3	241.85	241.3	241.85	12201.0
2020-06-16 05:00:00	QQQ	ETF	241.89	242.07	241.73	241.93	16175.0
2020-06-16 05:30:00	QQQ	ETF	241.92	242.06	241.64	241.66	18395.0
2020-06-16 06:00:00	QQQ	ETF	241.65	242.39	241.61	242.39	11897.0
2020-06-16 06:30:00	QQQ	ETF	242.4	242.47	242.01	242.12	13878.0
2020-06-16 07:00:00	QQQ	ETF	242.05	242.14	241.55	241.94	115520.0
2020-06-16 07:30:00	QQQ	ETF	241.9	242.45	241.76	242.39	64655.0
2020-06-16 08:00:00	QQQ	ETF	241.8001	243.13	241.12	243.01	193107.0
2020-06-16 08:30:00	QQQ	ETF	243.06	244.3	243.06	244.03	557655.0
2020-06-16 09:00:00	QQQ	ETF	244.06	244.18	243.52	243.78	306654.0
2020-06-16 09:30:00	QQQ	ETF	243.78	244.27	242.885	243.73	5190718.0
2020-06-16 10:00:00	QQQ	ETF	243.73	244.39	243.17	243.98	3059536.0
2020-06-16 10:30:00	QQQ	ETF	244.0	244.29	240.03	240.19	5462157.0
2020-06-16 11:00:00	QQQ	ETF	240.15	242.67	239.1	242.28	5518915.0
2020-06-16 11:30:00	QQQ	ETF	242.32	243.29	241.8	242.54	2957693.0
2020-06-16 12:00:00	QQQ	ETF	242.57	242.79	241.53	242.46	1986241.0
2020-06-16 12:30:00	QQQ	ETF	242.44	243.51	242.418	243.13	1883558.0

> showing 50 of 21,640 rows — these rows as CSV

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