PREVIEW / etf_30min / 2020-01-22

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-01-22.parquet
  size:    545 KB
  rows:    19,066

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-22 04:00:00	SPY	ETF	332.32	332.45	332.13	332.32	138418.0
2020-01-22 04:30:00	SPY	ETF	332.18	332.4	332.17	332.32	8814.0
2020-01-22 05:00:00	SPY	ETF	332.3	332.4	332.29	332.36	9237.0
2020-01-22 05:30:00	SPY	ETF	332.38	332.45	332.34	332.39	7563.0
2020-01-22 06:00:00	SPY	ETF	332.39	332.4	332.25	332.34	9168.0
2020-01-22 06:30:00	SPY	ETF	332.25	332.52	332.25	332.45	27325.0
2020-01-22 07:00:00	SPY	ETF	332.44	332.55	332.4	332.54	49071.0
2020-01-22 07:30:00	SPY	ETF	332.53	332.66	332.42	332.42	40353.0
2020-01-22 08:00:00	SPY	ETF	332.43	332.7	332.33	332.4	92556.0
2020-01-22 08:30:00	SPY	ETF	332.4	332.48	332.24	332.36	125645.0
2020-01-22 09:00:00	SPY	ETF	332.35	332.47	332.2	332.28	73894.0
2020-01-22 09:30:00	SPY	ETF	332.24	332.77	332.0	332.66	5869149.0
2020-01-22 10:00:00	SPY	ETF	332.66	332.8	332.28	332.715	5071085.0
2020-01-22 10:30:00	SPY	ETF	332.71	332.95	332.35	332.36	3460560.0
2020-01-22 11:00:00	SPY	ETF	332.36	332.3979	331.84	331.98	3494674.0
2020-01-22 11:30:00	SPY	ETF	331.975	332.25	331.92	332.04	4836187.0
2020-01-22 12:00:00	SPY	ETF	332.035	332.13	331.65	331.755	1598784.0
2020-01-22 12:30:00	SPY	ETF	331.77	332.18	331.73	332.16	1562090.0
2020-01-22 13:00:00	SPY	ETF	332.15	332.36	332.1	332.31	1269829.0
2020-01-22 13:30:00	SPY	ETF	332.31	332.4	332.05	332.06	1595564.0
2020-01-22 14:00:00	SPY	ETF	332.055	332.275	332.03	332.095	3359146.0
2020-01-22 14:30:00	SPY	ETF	332.09	332.125	331.925	332.045	1175262.0
2020-01-22 15:00:00	SPY	ETF	332.04	332.05	331.17	331.37	3973902.0
2020-01-22 15:30:00	SPY	ETF	331.36	331.78	331.32	331.39	5858455.0
2020-01-22 16:00:00	SPY	ETF	331.39	331.9864	331.19	331.23	3813104.0
2020-01-22 16:30:00	SPY	ETF	331.23	331.29	330.8	330.98	232298.0
2020-01-22 17:00:00	SPY	ETF	330.98	331.34	330.9	330.95	131580.0
2020-01-22 17:30:00	SPY	ETF	330.95	331.02	330.94	331.0	24757.0
2020-01-22 18:00:00	SPY	ETF	330.98	331.13	330.86	331.03	62860.0
2020-01-22 18:30:00	SPY	ETF	330.93	331.0	330.65	330.72	80792.0
2020-01-22 19:00:00	SPY	ETF	330.73	331.06	330.51	330.51	38527.0
2020-01-22 19:30:00	SPY	ETF	330.8	331.06	330.76	331.0	26119.0
2020-01-22 04:00:00	QQQ	ETF	224.25	224.53	224.25	224.34	19374.0
2020-01-22 04:30:00	QQQ	ETF	224.31	224.5	224.28	224.43	9568.0
2020-01-22 05:00:00	QQQ	ETF	224.42	224.55	224.39	224.54	3580.0
2020-01-22 05:30:00	QQQ	ETF	224.54	224.57	224.46	224.5	10070.0
2020-01-22 06:00:00	QQQ	ETF	224.49	224.57	224.44	224.46	9102.0
2020-01-22 06:30:00	QQQ	ETF	224.43	224.63	224.43	224.62	11900.0
2020-01-22 07:00:00	QQQ	ETF	224.61	224.78	224.59	224.78	37570.0
2020-01-22 07:30:00	QQQ	ETF	224.77	224.78	224.62	224.62	39633.0
2020-01-22 08:00:00	QQQ	ETF	224.63	224.75	224.43	224.58	126676.0
2020-01-22 08:30:00	QQQ	ETF	224.55	224.58	224.42	224.46	97823.0
2020-01-22 09:00:00	QQQ	ETF	224.43	224.54	224.37	224.44	81232.0
2020-01-22 09:30:00	QQQ	ETF	224.39	224.9	224.11	224.8	2640782.0
2020-01-22 10:00:00	QQQ	ETF	224.8001	224.939	224.45	224.8853	1394894.0
2020-01-22 10:30:00	QQQ	ETF	224.89	225.15	224.73	224.745	1147200.0
2020-01-22 11:00:00	QQQ	ETF	224.74	224.78	224.299	224.545	1169636.0
2020-01-22 11:30:00	QQQ	ETF	224.54	224.84	224.46	224.6	887625.0
2020-01-22 12:00:00	QQQ	ETF	224.6	224.66	224.32	224.4399	777215.0
2020-01-22 12:30:00	QQQ	ETF	224.43	224.83	224.42	224.81	653129.0

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

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