PREVIEW / etf_5min / 2009-12-10

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-12-10.parquet
  size:    673 KB
  rows:    29,847

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-12-10 04:30:00	SPY	ETF	110.1	110.1	110.1	110.1	1000.0
2009-12-10 04:35:00	SPY	ETF	110.14	110.14	110.14	110.14	200.0
2009-12-10 04:45:00	SPY	ETF	110.2	110.2	110.2	110.2	200.0
2009-12-10 04:55:00	SPY	ETF	110.07	110.11	110.07	110.11	200.0
2009-12-10 05:15:00	SPY	ETF	110.28	110.39	110.28	110.39	700.0
2009-12-10 05:30:00	SPY	ETF	110.47	110.47	110.47	110.47	500.0
2009-12-10 05:40:00	SPY	ETF	110.41	110.41	110.41	110.41	102.0
2009-12-10 05:45:00	SPY	ETF	110.34	110.34	110.34	110.34	2000.0
2009-12-10 06:00:00	SPY	ETF	110.43	110.44	110.43	110.44	5000.0
2009-12-10 06:25:00	SPY	ETF	110.4	110.4	110.4	110.4	1000.0
2009-12-10 06:30:00	SPY	ETF	110.45	110.45	110.45	110.45	200.0
2009-12-10 06:35:00	SPY	ETF	110.46	110.47	110.46	110.47	1824.0
2009-12-10 06:40:00	SPY	ETF	110.48	110.48	110.48	110.48	200.0
2009-12-10 06:50:00	SPY	ETF	110.44	110.44	110.44	110.44	200.0
2009-12-10 06:55:00	SPY	ETF	110.44	110.44	110.44	110.44	2000.0
2009-12-10 07:00:00	SPY	ETF	110.49	110.5	110.43	110.43	6880.0
2009-12-10 07:05:00	SPY	ETF	110.5	110.5	110.5	110.5	1000.0
2009-12-10 07:10:00	SPY	ETF	110.48	110.5	110.46	110.46	32600.0
2009-12-10 07:15:00	SPY	ETF	110.48	110.61	110.48	110.61	8525.0
2009-12-10 07:20:00	SPY	ETF	110.58	110.65	110.58	110.64	55500.0
2009-12-10 07:25:00	SPY	ETF	110.6	110.6	110.6	110.6	4400.0
2009-12-10 07:30:00	SPY	ETF	110.6	110.6	110.55	110.56	1500.0
2009-12-10 07:35:00	SPY	ETF	110.55	110.57	110.55	110.56	25904.0
2009-12-10 07:40:00	SPY	ETF	110.57	110.59	110.55	110.56	28800.0
2009-12-10 07:45:00	SPY	ETF	110.58	110.61	110.58	110.6	3500.0
2009-12-10 07:50:00	SPY	ETF	110.6	110.61	110.54	110.54	7444.0
2009-12-10 07:55:00	SPY	ETF	110.54	110.56	110.54	110.55	18963.0
2009-12-10 08:00:00	SPY	ETF	110.48	110.6	110.48	110.59	286684.0
2009-12-10 08:05:00	SPY	ETF	110.6	110.6	110.53	110.54	12650.0
2009-12-10 08:10:00	SPY	ETF	110.55	110.65	110.55	110.58	60602.0
2009-12-10 08:15:00	SPY	ETF	110.58	110.7	110.58	110.7	79129.0
2009-12-10 08:20:00	SPY	ETF	110.7	110.91	110.65	110.87	401749.0
2009-12-10 08:25:00	SPY	ETF	110.86	110.89	110.79	110.82	142067.0
2009-12-10 08:30:00	SPY	ETF	110.81	110.94	110.52	110.87	922005.0
2009-12-10 08:35:00	SPY	ETF	110.87	110.87	110.7	110.71	214544.0
2009-12-10 08:40:00	SPY	ETF	110.72	110.74	110.71	110.73	74875.0
2009-12-10 08:45:00	SPY	ETF	110.72	110.82	110.71	110.71	66114.0
2009-12-10 08:50:00	SPY	ETF	110.71	110.74	110.7	110.7	59608.0
2009-12-10 08:55:00	SPY	ETF	110.71	110.77	110.7	110.73	126077.0
2009-12-10 09:00:00	SPY	ETF	110.74	110.75	110.67	110.71	67427.0
2009-12-10 09:05:00	SPY	ETF	110.71	110.74	110.67	110.7	38416.0
2009-12-10 09:10:00	SPY	ETF	110.7	110.7	110.64	110.67	221217.0
2009-12-10 09:15:00	SPY	ETF	110.67	110.72	110.66	110.69	103621.0
2009-12-10 09:20:00	SPY	ETF	110.7	110.7	110.66	110.67	52464.0
2009-12-10 09:25:00	SPY	ETF	110.67	110.76	110.67	110.69	397831.0
2009-12-10 09:30:00	SPY	ETF	110.7	110.94	110.68	110.86	4965632.0
2009-12-10 09:35:00	SPY	ETF	110.87	111.11	110.8	111.02	4355896.0
2009-12-10 09:40:00	SPY	ETF	111.019	111.12	110.96	110.98	2651905.0
2009-12-10 09:45:00	SPY	ETF	110.99	111.11	110.94	111.01	2769746.0
2009-12-10 09:50:00	SPY	ETF	111.0	111.01	110.78	110.82	2547368.0

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

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