PREVIEW / etf_5min / 2007-01-19

all etf 5-min files

  file:    by_date/etf_5min/2007/2007-01-19.parquet
  size:    283 KB
  rows:    13,481

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
2007-01-19 04:25:00	SPY	ETF	142.5	142.5	142.5	142.5	1900.0
2007-01-19 07:00:00	SPY	ETF	142.44	142.44	142.44	142.44	11600.0
2007-01-19 07:05:00	SPY	ETF	142.44	142.44	142.44	142.44	3300.0
2007-01-19 07:10:00	SPY	ETF	142.46	142.46	142.46	142.46	500.0
2007-01-19 07:15:00	SPY	ETF	142.49	142.49	142.49	142.49	500.0
2007-01-19 07:20:00	SPY	ETF	142.44	142.44	142.44	142.44	200.0
2007-01-19 07:30:00	SPY	ETF	142.43	142.43	142.4	142.4	27800.0
2007-01-19 07:35:00	SPY	ETF	142.35	142.35	142.35	142.35	400.0
2007-01-19 07:40:00	SPY	ETF	142.39	142.45	142.39	142.45	11900.0
2007-01-19 07:45:00	SPY	ETF	142.43	142.5	142.43	142.5	6000.0
2007-01-19 07:50:00	SPY	ETF	142.49	142.5	142.43	142.46	3100.0
2007-01-19 08:00:00	SPY	ETF	142.45	142.5	142.35	142.35	112600.0
2007-01-19 08:05:00	SPY	ETF	142.35	142.38	142.35	142.38	26900.0
2007-01-19 08:10:00	SPY	ETF	142.38	142.41	142.38	142.4	29000.0
2007-01-19 08:15:00	SPY	ETF	142.4	142.41	142.38	142.41	64500.0
2007-01-19 08:20:00	SPY	ETF	142.41	142.42	142.41	142.41	69600.0
2007-01-19 08:25:00	SPY	ETF	142.43	142.48	142.42	142.48	62300.0
2007-01-19 08:30:00	SPY	ETF	142.46	142.46	142.41	142.43	369700.0
2007-01-19 08:35:00	SPY	ETF	142.4	142.43	142.4	142.4	26200.0
2007-01-19 08:40:00	SPY	ETF	142.4	142.4	142.38	142.39	55100.0
2007-01-19 08:45:00	SPY	ETF	142.37	142.46	142.37	142.46	49500.0
2007-01-19 08:50:00	SPY	ETF	142.46	142.47	142.4	142.41	40900.0
2007-01-19 08:55:00	SPY	ETF	142.41	142.48	142.41	142.48	38900.0
2007-01-19 09:00:00	SPY	ETF	142.48	142.54	142.48	142.5	38100.0
2007-01-19 09:05:00	SPY	ETF	142.5	142.5	142.46	142.46	15800.0
2007-01-19 09:10:00	SPY	ETF	142.46	142.54	142.46	142.53	58200.0
2007-01-19 09:15:00	SPY	ETF	142.54	142.55	142.51	142.51	144700.0
2007-01-19 09:20:00	SPY	ETF	142.5	142.57	142.5	142.57	286400.0
2007-01-19 09:25:00	SPY	ETF	142.55	142.67	142.52	142.52	341400.0
2007-01-19 09:30:00	SPY	ETF	142.54	142.62	142.46	142.57	1625400.0
2007-01-19 09:35:00	SPY	ETF	142.57	142.74	142.53	142.68	1485300.0
2007-01-19 09:40:00	SPY	ETF	142.68	142.84	142.57	142.61	1407600.0
2007-01-19 09:45:00	SPY	ETF	142.6	142.61	142.51	142.58	885300.0
2007-01-19 09:50:00	SPY	ETF	142.57	142.57	142.47	142.51	920600.0
2007-01-19 09:55:00	SPY	ETF	142.51	142.55	142.49	142.54	774000.0
2007-01-19 10:00:00	SPY	ETF	142.55	142.8	142.49	142.54	1817800.0
2007-01-19 10:05:00	SPY	ETF	142.53	142.66	142.5	142.61	1266300.0
2007-01-19 10:10:00	SPY	ETF	142.6	142.73	142.58	142.61	659200.0
2007-01-19 10:15:00	SPY	ETF	142.62	142.7	142.55	142.58	815800.0
2007-01-19 10:20:00	SPY	ETF	142.58	142.62	142.54	142.61	1288600.0
2007-01-19 10:25:00	SPY	ETF	142.61	142.69	142.59	142.66	592600.0
2007-01-19 10:30:00	SPY	ETF	142.67	142.77	142.6	142.63	610300.0
2007-01-19 10:35:00	SPY	ETF	142.62	142.77	142.59	142.7	1509700.0
2007-01-19 10:40:00	SPY	ETF	142.7	142.9	142.66	142.88	1675700.0
2007-01-19 10:45:00	SPY	ETF	142.87	142.98	142.86	142.91	1629900.0
2007-01-19 10:50:00	SPY	ETF	142.92	142.94	142.89	142.94	563100.0
2007-01-19 10:55:00	SPY	ETF	142.94	143.1	142.93	142.97	1011300.0
2007-01-19 11:00:00	SPY	ETF	142.96	143.04	142.94	142.99	911200.0
2007-01-19 11:05:00	SPY	ETF	142.98	143.0	142.94	142.96	347100.0
2007-01-19 11:10:00	SPY	ETF	142.96	143.01	142.95	142.99	680200.0

> showing 50 of 13,481 rows — these rows as CSV

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