PREVIEW / etf_5min / 2009-07-14

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-07-14.parquet
  size:    665 KB
  rows:    29,035

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-14 04:15:00	SPY	ETF	90.23	90.23	90.19	90.22	33200.0
2009-07-14 04:30:00	SPY	ETF	90.3	90.34	90.3	90.34	600.0
2009-07-14 05:00:00	SPY	ETF	90.17	90.17	90.11	90.11	700.0
2009-07-14 05:25:00	SPY	ETF	90.26	90.26	90.26	90.26	100.0
2009-07-14 05:35:00	SPY	ETF	90.35	90.35	90.35	90.35	182.0
2009-07-14 05:55:00	SPY	ETF	90.31	90.32	90.31	90.32	15000.0
2009-07-14 06:10:00	SPY	ETF	90.24	90.24	90.24	90.24	500.0
2009-07-14 06:25:00	SPY	ETF	90.21	90.21	90.21	90.21	100.0
2009-07-14 06:35:00	SPY	ETF	90.17	90.17	90.17	90.17	200.0
2009-07-14 06:40:00	SPY	ETF	90.24	90.24	90.24	90.24	400.0
2009-07-14 06:45:00	SPY	ETF	90.22	90.22	90.22	90.22	3100.0
2009-07-14 06:50:00	SPY	ETF	90.18	90.18	90.18	90.18	500.0
2009-07-14 07:00:00	SPY	ETF	90.11	90.12	90.1	90.11	26750.0
2009-07-14 07:05:00	SPY	ETF	90.11	90.13	90.11	90.11	6900.0
2009-07-14 07:10:00	SPY	ETF	90.11	90.2	90.11	90.2	11600.0
2009-07-14 07:15:00	SPY	ETF	90.19	90.31	90.19	90.28	13700.0
2009-07-14 07:20:00	SPY	ETF	90.3	90.32	90.3	90.32	9200.0
2009-07-14 07:25:00	SPY	ETF	90.33	90.34	90.25	90.3	34500.0
2009-07-14 07:30:00	SPY	ETF	90.28	90.44	90.28	90.41	40848.0
2009-07-14 07:35:00	SPY	ETF	90.38	90.46	90.38	90.45	35923.0
2009-07-14 07:40:00	SPY	ETF	90.45	90.61	90.44	90.56	178032.0
2009-07-14 07:45:00	SPY	ETF	90.51	90.67	90.48	90.63	386698.0
2009-07-14 07:50:00	SPY	ETF	90.64	90.66	90.57	90.6	163760.0
2009-07-14 07:55:00	SPY	ETF	90.59	90.77	90.55	90.73	99112.0
2009-07-14 08:00:00	SPY	ETF	90.71	90.73	90.53	90.67	279595.0
2009-07-14 08:05:00	SPY	ETF	90.67	90.7	90.61	90.61	90202.0
2009-07-14 08:10:00	SPY	ETF	90.61	90.68	90.61	90.66	52144.0
2009-07-14 08:15:00	SPY	ETF	90.66	90.83	90.4	90.41	1418051.0
2009-07-14 08:20:00	SPY	ETF	90.41	90.5	90.27	90.48	1089267.0
2009-07-14 08:25:00	SPY	ETF	90.47	90.65	90.43	90.61	780693.0
2009-07-14 08:30:00	SPY	ETF	90.62	90.62	90.33	90.37	1174827.0
2009-07-14 08:35:00	SPY	ETF	90.37	90.38	90.08	90.27	718447.0
2009-07-14 08:40:00	SPY	ETF	90.28	90.3	89.96	90.07	1040809.0
2009-07-14 08:45:00	SPY	ETF	90.05	90.25	89.99	90.25	734955.0
2009-07-14 08:50:00	SPY	ETF	90.25	90.3	90.19	90.2	241587.0
2009-07-14 08:55:00	SPY	ETF	90.22	90.26	90.18	90.18	19982.0
2009-07-14 09:00:00	SPY	ETF	90.18	90.18	90.05	90.14	108560.0
2009-07-14 09:05:00	SPY	ETF	90.15	90.38	90.15	90.34	429565.0
2009-07-14 09:10:00	SPY	ETF	90.34	90.49	90.27	90.33	334379.0
2009-07-14 09:15:00	SPY	ETF	90.35	90.46	90.34	90.42	182284.0
2009-07-14 09:20:00	SPY	ETF	90.39	90.41	90.34	90.35	82719.0
2009-07-14 09:25:00	SPY	ETF	90.34	90.41	90.33	90.39	274552.0
2009-07-14 09:30:00	SPY	ETF	90.38	90.42	90.13	90.39	3272195.0
2009-07-14 09:35:00	SPY	ETF	90.39	90.59	90.22	90.39	6933761.0
2009-07-14 09:40:00	SPY	ETF	90.38	90.49	90.11	90.11	4851145.0
2009-07-14 09:45:00	SPY	ETF	90.11	90.19	90.02	90.1583	3153530.0
2009-07-14 09:50:00	SPY	ETF	90.16	90.27	89.94	90.05	3241438.0
2009-07-14 09:55:00	SPY	ETF	90.0499	90.11	89.91	90.0078	3289037.0
2009-07-14 10:00:00	SPY	ETF	90.0	90.25	89.96	90.12	3129731.0
2009-07-14 10:05:00	SPY	ETF	90.12	90.4	90.04	90.26	3275779.0

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

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