PREVIEW / etf_5min / 2009-07-31

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-07-31.parquet
  size:    702 KB
  rows:    29,923

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
2009-07-31 04:55:00	SPY	ETF	98.78	98.78	98.78	98.78	1000.0
2009-07-31 05:15:00	SPY	ETF	98.8	98.83	98.8	98.83	200.0
2009-07-31 05:40:00	SPY	ETF	98.88	98.88	98.88	98.88	2500.0
2009-07-31 05:55:00	SPY	ETF	98.88	98.88	98.88	98.88	2480.0
2009-07-31 06:05:00	SPY	ETF	98.92	98.92	98.92	98.92	2500.0
2009-07-31 06:35:00	SPY	ETF	98.97	98.97	98.97	98.97	300.0
2009-07-31 06:40:00	SPY	ETF	99.04	99.04	99.04	99.04	100.0
2009-07-31 06:45:00	SPY	ETF	99.08	99.08	99.08	99.08	500.0
2009-07-31 06:50:00	SPY	ETF	99.09	99.09	99.09	99.09	100.0
2009-07-31 06:55:00	SPY	ETF	99.05	99.05	98.93	98.96	5100.0
2009-07-31 07:00:00	SPY	ETF	99.01	99.04	98.96	99.03	39956.0
2009-07-31 07:05:00	SPY	ETF	99.05	99.09	99.0	99.08	20493.0
2009-07-31 07:10:00	SPY	ETF	99.09	99.11	99.08	99.1	13350.0
2009-07-31 07:15:00	SPY	ETF	99.05	99.06	99.05	99.06	1200.0
2009-07-31 07:20:00	SPY	ETF	99.05	99.1	99.05	99.1	46277.0
2009-07-31 07:25:00	SPY	ETF	99.1	99.1	98.99	99.0	134707.0
2009-07-31 07:30:00	SPY	ETF	99.0	99.01	98.96	98.98	209874.0
2009-07-31 07:35:00	SPY	ETF	98.98	99.06	98.96	99.04	32259.0
2009-07-31 07:40:00	SPY	ETF	99.05	99.1	99.05	99.1	55200.0
2009-07-31 07:45:00	SPY	ETF	99.09	99.1	99.02	99.02	55200.0
2009-07-31 07:50:00	SPY	ETF	99.04	99.09	99.03	99.03	280064.0
2009-07-31 07:55:00	SPY	ETF	99.04	99.04	99.01	99.02	121800.0
2009-07-31 08:00:00	SPY	ETF	99.03	99.03	98.97	99.01	647602.0
2009-07-31 08:05:00	SPY	ETF	99.01	99.11	98.99	99.09	996750.0
2009-07-31 08:10:00	SPY	ETF	99.09	99.22	99.07	99.19	901617.0
2009-07-31 08:15:00	SPY	ETF	99.18	99.21	99.18	99.21	102828.0
2009-07-31 08:20:00	SPY	ETF	99.21	99.21	99.15	99.17	135877.0
2009-07-31 08:25:00	SPY	ETF	99.17	99.23	99.17	99.17	178564.0
2009-07-31 08:30:00	SPY	ETF	99.25	99.53	98.73	98.84	2425386.0
2009-07-31 08:35:00	SPY	ETF	98.84	98.85	98.28	98.39	2254206.0
2009-07-31 08:40:00	SPY	ETF	98.4	98.51	98.37	98.4	889180.0
2009-07-31 08:45:00	SPY	ETF	98.4	98.5	98.34	98.42	634293.0
2009-07-31 08:50:00	SPY	ETF	98.42	98.49	98.29	98.43	601780.0
2009-07-31 08:55:00	SPY	ETF	98.44	98.45	98.27	98.33	352523.0
2009-07-31 09:00:00	SPY	ETF	98.33	98.45	98.3	98.38	240226.0
2009-07-31 09:05:00	SPY	ETF	98.38	98.44	98.32	98.4	211122.0
2009-07-31 09:10:00	SPY	ETF	98.4	98.44	98.36	98.44	173648.0
2009-07-31 09:15:00	SPY	ETF	98.43	98.47	98.39	98.45	143634.0
2009-07-31 09:20:00	SPY	ETF	98.45	98.67	98.45	98.66	385606.0
2009-07-31 09:25:00	SPY	ETF	98.65	98.7	98.6	98.64	265706.0
2009-07-31 09:30:00	SPY	ETF	98.65	98.84	98.56	98.825	5942037.0
2009-07-31 09:35:00	SPY	ETF	98.83	99.08	98.81	98.95	5789544.0
2009-07-31 09:40:00	SPY	ETF	98.96	99.33	98.94	99.19	6163662.0
2009-07-31 09:45:00	SPY	ETF	99.17	99.46	99.12	99.27	4095893.0
2009-07-31 09:50:00	SPY	ETF	99.27	99.33	99.0	99.12	4488121.0
2009-07-31 09:55:00	SPY	ETF	99.11	99.18	98.88	98.92	6154320.0
2009-07-31 10:00:00	SPY	ETF	98.92	99.1	98.42	98.62	10378218.0
2009-07-31 10:05:00	SPY	ETF	98.63	98.76	98.38	98.72	5110580.0
2009-07-31 10:10:00	SPY	ETF	98.72	98.93	98.71	98.8283	7139651.0
2009-07-31 10:15:00	SPY	ETF	98.83	98.97	98.76	98.8	3745157.0

> showing 50 of 29,923 rows — these rows as CSV

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