PREVIEW / etf_5min / 2009-07-29

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-07-29.parquet
  size:    681 KB
  rows:    29,238

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-29 04:10:00	SPY	ETF	97.58	97.58	97.58	97.58	100.0
2009-07-29 04:15:00	SPY	ETF	97.67	97.86	97.67	97.86	2400.0
2009-07-29 04:20:00	SPY	ETF	97.76	97.76	97.76	97.76	100.0
2009-07-29 04:25:00	SPY	ETF	97.66	97.66	97.66	97.66	100.0
2009-07-29 05:05:00	SPY	ETF	97.66	97.66	97.66	97.66	2000.0
2009-07-29 05:25:00	SPY	ETF	97.67	97.76	97.67	97.76	2100.0
2009-07-29 05:35:00	SPY	ETF	97.66	97.66	97.66	97.66	100.0
2009-07-29 05:40:00	SPY	ETF	97.62	97.62	97.6	97.6	67500.0
2009-07-29 05:45:00	SPY	ETF	97.59	97.6	97.56	97.58	32650.0
2009-07-29 05:50:00	SPY	ETF	97.55	97.55	97.55	97.55	700.0
2009-07-29 05:55:00	SPY	ETF	97.52	97.52	97.4	97.4	6350.0
2009-07-29 06:00:00	SPY	ETF	97.47	97.55	97.47	97.54	7600.0
2009-07-29 06:05:00	SPY	ETF	97.54	97.57	97.5	97.57	1400.0
2009-07-29 06:10:00	SPY	ETF	97.62	97.62	97.62	97.62	150.0
2009-07-29 06:15:00	SPY	ETF	97.59	97.7	97.59	97.7	27700.0
2009-07-29 06:35:00	SPY	ETF	97.76	97.76	97.72	97.73	30100.0
2009-07-29 06:40:00	SPY	ETF	97.8	97.81	97.72	97.72	4700.0
2009-07-29 06:45:00	SPY	ETF	97.77	97.81	97.77	97.79	14500.0
2009-07-29 06:50:00	SPY	ETF	97.78	97.78	97.76	97.77	6300.0
2009-07-29 06:55:00	SPY	ETF	97.77	97.77	97.67	97.67	6500.0
2009-07-29 07:00:00	SPY	ETF	97.75	97.75	97.65	97.65	14096.0
2009-07-29 07:05:00	SPY	ETF	97.68	97.72	97.68	97.72	2000.0
2009-07-29 07:10:00	SPY	ETF	97.7	97.71	97.66	97.7	7000.0
2009-07-29 07:15:00	SPY	ETF	97.72	97.72	97.65	97.68	13802.0
2009-07-29 07:20:00	SPY	ETF	97.7	97.71	97.68	97.68	6800.0
2009-07-29 07:25:00	SPY	ETF	97.7	97.7	97.57	97.57	92498.0
2009-07-29 07:30:00	SPY	ETF	97.58	97.59	97.53	97.55	60190.0
2009-07-29 07:35:00	SPY	ETF	97.53	97.53	97.43	97.43	93053.0
2009-07-29 07:40:00	SPY	ETF	97.49	97.54	97.45	97.49	131354.0
2009-07-29 07:45:00	SPY	ETF	97.49	97.55	97.49	97.55	32993.0
2009-07-29 07:50:00	SPY	ETF	97.56	97.63	97.56	97.6	66787.0
2009-07-29 07:55:00	SPY	ETF	97.6	97.62	97.43	97.43	224613.0
2009-07-29 08:00:00	SPY	ETF	97.43	97.67	97.42	97.5	1378296.0
2009-07-29 08:05:00	SPY	ETF	97.5	97.55	97.48	97.55	99451.0
2009-07-29 08:10:00	SPY	ETF	97.56	97.63	97.14	97.5	266601.0
2009-07-29 08:15:00	SPY	ETF	97.5	97.56	97.46	97.51	174596.0
2009-07-29 08:20:00	SPY	ETF	97.5	97.66	97.5	97.62	217065.0
2009-07-29 08:25:00	SPY	ETF	97.63	97.77	97.62	97.72	302507.0
2009-07-29 08:30:00	SPY	ETF	97.72	97.84	97.37	97.6	1936600.0
2009-07-29 08:35:00	SPY	ETF	97.6	97.6	97.29	97.32	690635.0
2009-07-29 08:40:00	SPY	ETF	97.31	97.41	97.3	97.33	670645.0
2009-07-29 08:45:00	SPY	ETF	97.33	97.39	97.3	97.37	199318.0
2009-07-29 08:50:00	SPY	ETF	97.36	97.36	97.31	97.34	92174.0
2009-07-29 08:55:00	SPY	ETF	97.33	97.38	97.28	97.37	178631.0
2009-07-29 09:00:00	SPY	ETF	97.36	97.48	97.36	97.42	485533.0
2009-07-29 09:05:00	SPY	ETF	97.43	97.44	97.36	97.36	256987.0
2009-07-29 09:10:00	SPY	ETF	97.36	97.37	97.26	97.35	423053.0
2009-07-29 09:15:00	SPY	ETF	97.36	97.4	97.31	97.38	362019.0
2009-07-29 09:20:00	SPY	ETF	97.38	97.43	97.35	97.37	247630.0
2009-07-29 09:25:00	SPY	ETF	97.37	97.45	97.15	97.45	307057.0

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

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