PREVIEW / etf_1min / 2010-01-15

all etf 1-min files

  file:    by_date/etf_1min/2010/2010-01-15.parquet
  size:    1.7 MB
  rows:    94,348

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
2010-01-15 04:30:00	SPY	ETF	114.98	114.98	114.98	114.98	300.0
2010-01-15 05:09:00	SPY	ETF	114.75	114.75	114.75	114.75	800.0
2010-01-15 05:34:00	SPY	ETF	114.75	114.75	114.75	114.75	100.0
2010-01-15 05:42:00	SPY	ETF	114.79	114.8	114.79	114.8	3100.0
2010-01-15 06:22:00	SPY	ETF	114.66	114.66	114.66	114.66	12700.0
2010-01-15 06:25:00	SPY	ETF	114.65	114.65	114.65	114.65	300.0
2010-01-15 06:28:00	SPY	ETF	114.68	114.68	114.68	114.68	100.0
2010-01-15 06:43:00	SPY	ETF	114.65	114.65	114.65	114.65	10000.0
2010-01-15 06:46:00	SPY	ETF	114.68	114.68	114.68	114.68	500.0
2010-01-15 06:52:00	SPY	ETF	114.65	114.65	114.65	114.65	5000.0
2010-01-15 06:54:00	SPY	ETF	114.65	114.65	114.65	114.65	4900.0
2010-01-15 06:56:00	SPY	ETF	114.7	114.7	114.69	114.69	3000.0
2010-01-15 06:57:00	SPY	ETF	114.72	114.74	114.72	114.74	2900.0
2010-01-15 06:58:00	SPY	ETF	114.75	114.75	114.75	114.75	2000.0
2010-01-15 06:59:00	SPY	ETF	114.82	114.82	114.75	114.75	5500.0
2010-01-15 07:00:00	SPY	ETF	114.6	114.66	114.55	114.55	57100.0
2010-01-15 07:01:00	SPY	ETF	114.55	114.63	114.54	114.63	13400.0
2010-01-15 07:02:00	SPY	ETF	114.65	114.65	114.59	114.6	12300.0
2010-01-15 07:03:00	SPY	ETF	114.58	114.58	114.51	114.52	6400.0
2010-01-15 07:04:00	SPY	ETF	114.52	114.6	114.49	114.49	34500.0
2010-01-15 07:05:00	SPY	ETF	114.44	114.45	114.32	114.37	56000.0
2010-01-15 07:06:00	SPY	ETF	114.35	114.37	114.32	114.37	17350.0
2010-01-15 07:07:00	SPY	ETF	114.37	114.37	114.37	114.37	2450.0
2010-01-15 07:08:00	SPY	ETF	114.38	114.38	114.35	114.35	2450.0
2010-01-15 07:09:00	SPY	ETF	114.33	114.42	114.33	114.42	3976.0
2010-01-15 07:10:00	SPY	ETF	114.38	114.38	114.25	114.25	35001.0
2010-01-15 07:11:00	SPY	ETF	114.25	114.27	114.21	114.27	11899.0
2010-01-15 07:12:00	SPY	ETF	114.26	114.3	114.26	114.3	800.0
2010-01-15 07:13:00	SPY	ETF	114.35	114.35	114.32	114.32	4500.0
2010-01-15 07:14:00	SPY	ETF	114.32	114.42	114.32	114.33	12201.0
2010-01-15 07:15:00	SPY	ETF	114.37	114.4	114.36	114.4	8500.0
2010-01-15 07:16:00	SPY	ETF	114.4	114.4	114.38	114.38	4200.0
2010-01-15 07:17:00	SPY	ETF	114.4	114.42	114.37	114.37	9600.0
2010-01-15 07:18:00	SPY	ETF	114.4	114.42	114.4	114.42	201000.0
2010-01-15 07:19:00	SPY	ETF	114.42	114.42	114.4	114.4	100400.0
2010-01-15 07:20:00	SPY	ETF	114.4	114.42	114.39	114.42	80835.0
2010-01-15 07:21:00	SPY	ETF	114.4	114.43	114.4	114.43	22425.0
2010-01-15 07:23:00	SPY	ETF	114.44	114.45	114.42	114.45	6100.0
2010-01-15 07:24:00	SPY	ETF	114.46	114.48	114.46	114.48	10000.0
2010-01-15 07:25:00	SPY	ETF	114.5	114.5	114.48	114.48	300.0
2010-01-15 07:26:00	SPY	ETF	114.49	114.49	114.47	114.47	1000.0
2010-01-15 07:27:00	SPY	ETF	114.44	114.44	114.44	114.44	1000.0
2010-01-15 07:28:00	SPY	ETF	114.46	114.46	114.46	114.46	2800.0
2010-01-15 07:29:00	SPY	ETF	114.5	114.5	114.47	114.49	11600.0
2010-01-15 07:30:00	SPY	ETF	114.46	114.53	114.46	114.53	22000.0
2010-01-15 07:31:00	SPY	ETF	114.53	114.54	114.53	114.53	14900.0
2010-01-15 07:32:00	SPY	ETF	114.55	114.55	114.5	114.5	2700.0
2010-01-15 07:33:00	SPY	ETF	114.49	114.51	114.49	114.51	160000.0
2010-01-15 07:34:00	SPY	ETF	114.5	114.5	114.49	114.49	19400.0
2010-01-15 07:35:00	SPY	ETF	114.5	114.5	114.5	114.5	71200.0

> showing 50 of 94,348 rows — these rows as CSV

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