PREVIEW / etf_5min / 2008-01-11

all etf 5-min files

  file:    by_date/etf_5min/2008/2008-01-11.parquet
  size:    458 KB
  rows:    22,034

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
2008-01-11 04:05:00	SPY	ETF	140.6	140.6	140.6	140.6	1000.0
2008-01-11 04:15:00	SPY	ETF	140.47	140.47	140.41	140.41	1100.0
2008-01-11 04:25:00	SPY	ETF	140.49	140.49	140.49	140.49	1000.0
2008-01-11 04:50:00	SPY	ETF	140.62	140.62	140.62	140.62	1000.0
2008-01-11 04:55:00	SPY	ETF	140.75	140.75	140.75	140.75	1000.0
2008-01-11 05:20:00	SPY	ETF	140.6	140.6	140.6	140.6	600.0
2008-01-11 05:25:00	SPY	ETF	140.55	140.55	140.54	140.54	600.0
2008-01-11 05:40:00	SPY	ETF	140.64	140.7	140.61	140.61	51000.0
2008-01-11 05:55:00	SPY	ETF	140.56	140.56	140.51	140.51	15000.0
2008-01-11 06:00:00	SPY	ETF	140.48	140.48	140.45	140.45	17500.0
2008-01-11 06:10:00	SPY	ETF	140.42	140.46	140.42	140.46	2700.0
2008-01-11 06:25:00	SPY	ETF	140.4	140.4	140.39	140.39	15000.0
2008-01-11 06:40:00	SPY	ETF	140.38	140.38	140.3	140.3	700.0
2008-01-11 06:45:00	SPY	ETF	140.24	140.25	139.95	139.95	43700.0
2008-01-11 06:50:00	SPY	ETF	140.15	140.15	139.95	139.95	50400.0
2008-01-11 06:55:00	SPY	ETF	139.95	140.06	139.85	140.06	82600.0
2008-01-11 07:00:00	SPY	ETF	140.12	140.48	140.1	140.25	367700.0
2008-01-11 07:05:00	SPY	ETF	140.22	140.37	140.17	140.36	165700.0
2008-01-11 07:10:00	SPY	ETF	140.42	140.44	140.23	140.23	157200.0
2008-01-11 07:15:00	SPY	ETF	140.21	140.26	140.12	140.2	237700.0
2008-01-11 07:20:00	SPY	ETF	140.2	140.24	140.05	140.1	330600.0
2008-01-11 07:25:00	SPY	ETF	140.15	140.2	140.1	140.15	272900.0
2008-01-11 07:30:00	SPY	ETF	140.12	140.16	139.9	139.99	451300.0
2008-01-11 07:35:00	SPY	ETF	139.99	140.11	139.92	140.05	111400.0
2008-01-11 07:40:00	SPY	ETF	140.05	140.47	140.05	140.44	395400.0
2008-01-11 07:45:00	SPY	ETF	140.44	140.65	140.38	140.65	694000.0
2008-01-11 07:50:00	SPY	ETF	140.63	141.3	140.45	140.54	684300.0
2008-01-11 07:55:00	SPY	ETF	140.54	140.73	140.51	140.58	212600.0
2008-01-11 08:00:00	SPY	ETF	140.58	140.77	140.13	140.72	715000.0
2008-01-11 08:05:00	SPY	ETF	140.7	140.7	140.58	140.58	202500.0
2008-01-11 08:10:00	SPY	ETF	140.6	140.6	140.47	140.54	285000.0
2008-01-11 08:15:00	SPY	ETF	140.53	140.57	140.5	140.55	84600.0
2008-01-11 08:20:00	SPY	ETF	140.55	140.59	140.45	140.54	161100.0
2008-01-11 08:25:00	SPY	ETF	140.53	140.57	140.49	140.49	168700.0
2008-01-11 08:30:00	SPY	ETF	140.49	140.53	140.32	140.44	1169605.0
2008-01-11 08:35:00	SPY	ETF	140.43	140.8	140.14	140.78	1916700.0
2008-01-11 08:40:00	SPY	ETF	140.76	140.85	139.9	140.82	1127800.0
2008-01-11 08:45:00	SPY	ETF	140.82	140.82	140.71	140.74	277100.0
2008-01-11 08:50:00	SPY	ETF	140.74	140.74	139.95	140.66	189800.0
2008-01-11 08:55:00	SPY	ETF	140.66	140.7	140.62	140.68	53400.0
2008-01-11 09:00:00	SPY	ETF	140.68	140.89	140.68	140.88	404600.0
2008-01-11 09:05:00	SPY	ETF	140.87	140.91	140.75	140.82	435200.0
2008-01-11 09:10:00	SPY	ETF	140.81	140.84	140.71	140.75	348100.0
2008-01-11 09:15:00	SPY	ETF	140.74	140.79	140.7	140.78	138700.0
2008-01-11 09:20:00	SPY	ETF	140.76	140.8	140.61	140.62	265352.0
2008-01-11 09:25:00	SPY	ETF	140.64	140.76	140.6	140.72	158400.0
2008-01-11 09:30:00	SPY	ETF	140.78	140.82	140.6	140.69	4520441.0
2008-01-11 09:35:00	SPY	ETF	140.7	140.75	140.0	140.58	6740833.0
2008-01-11 09:40:00	SPY	ETF	140.57	140.85	140.41	140.81	6464757.0
2008-01-11 09:45:00	SPY	ETF	140.81	141.01	140.66	141.01	3534521.0

> showing 50 of 22,034 rows — these rows as CSV

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