PREVIEW / etf_1min / 2009-10-15

all etf 1-min files

  file:    by_date/etf_1min/2009/2009-10-15.parquet
  size:    1.7 MB
  rows:    92,006

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-10-15 04:20:00	SPY	ETF	109.2	109.2	109.2	109.2	100.0
2009-10-15 05:22:00	SPY	ETF	109.28	109.28	109.28	109.28	2000.0
2009-10-15 06:01:00	SPY	ETF	109.3	109.3	109.3	109.3	800.0
2009-10-15 06:05:00	SPY	ETF	109.25	109.25	109.23	109.23	400.0
2009-10-15 06:07:00	SPY	ETF	109.19	109.19	109.19	109.19	4100.0
2009-10-15 06:41:00	SPY	ETF	109.28	109.28	109.28	109.28	200.0
2009-10-15 06:57:00	SPY	ETF	109.22	109.22	109.22	109.22	7700.0
2009-10-15 07:00:00	SPY	ETF	109.3	109.3	109.3	109.3	1000.0
2009-10-15 07:01:00	SPY	ETF	109.3	109.3	109.27	109.27	6341.0
2009-10-15 07:03:00	SPY	ETF	109.27	109.27	109.27	109.27	381.0
2009-10-15 07:04:00	SPY	ETF	109.31	109.31	109.31	109.31	3750.0
2009-10-15 07:05:00	SPY	ETF	109.33	109.35	109.33	109.35	200.0
2009-10-15 07:06:00	SPY	ETF	109.36	109.41	109.36	109.41	22900.0
2009-10-15 07:07:00	SPY	ETF	109.37	109.37	109.37	109.37	500.0
2009-10-15 07:08:00	SPY	ETF	109.39	109.4	109.39	109.4	2400.0
2009-10-15 07:09:00	SPY	ETF	109.42	109.42	109.42	109.42	700.0
2009-10-15 07:10:00	SPY	ETF	109.45	109.45	109.43	109.43	32450.0
2009-10-15 07:12:00	SPY	ETF	109.42	109.42	109.38	109.39	52500.0
2009-10-15 07:14:00	SPY	ETF	109.33	109.33	109.33	109.33	3000.0
2009-10-15 07:15:00	SPY	ETF	109.34	109.34	109.16	109.19	260254.0
2009-10-15 07:16:00	SPY	ETF	109.17	109.19	109.14	109.15	154700.0
2009-10-15 07:17:00	SPY	ETF	109.14	109.17	109.13	109.15	170900.0
2009-10-15 07:18:00	SPY	ETF	109.11	109.11	109.07	109.08	36800.0
2009-10-15 07:19:00	SPY	ETF	109.08	109.17	109.08	109.14	86485.0
2009-10-15 07:20:00	SPY	ETF	109.12	109.12	109.09	109.09	6300.0
2009-10-15 07:21:00	SPY	ETF	109.11	109.11	109.07	109.08	17000.0
2009-10-15 07:22:00	SPY	ETF	109.04	109.07	109.01	109.01	61690.0
2009-10-15 07:23:00	SPY	ETF	109.04	109.04	109.01	109.01	7400.0
2009-10-15 07:24:00	SPY	ETF	109.01	109.01	108.94	108.96	62700.0
2009-10-15 07:25:00	SPY	ETF	108.98	109.0	108.95	108.98	77900.0
2009-10-15 07:26:00	SPY	ETF	108.98	108.98	108.87	108.91	14600.0
2009-10-15 07:27:00	SPY	ETF	108.87	108.91	108.87	108.88	30050.0
2009-10-15 07:28:00	SPY	ETF	108.89	108.91	108.89	108.91	13900.0
2009-10-15 07:29:00	SPY	ETF	108.89	108.91	108.88	108.91	11100.0
2009-10-15 07:30:00	SPY	ETF	108.91	108.97	108.91	108.97	29502.0
2009-10-15 07:31:00	SPY	ETF	108.94	108.94	108.87	108.89	7400.0
2009-10-15 07:32:00	SPY	ETF	108.87	108.87	108.86	108.86	26175.0
2009-10-15 07:33:00	SPY	ETF	108.86	108.86	108.86	108.86	5300.0
2009-10-15 07:34:00	SPY	ETF	108.87	108.92	108.87	108.89	3604.0
2009-10-15 07:35:00	SPY	ETF	108.89	108.89	108.84	108.85	33400.0
2009-10-15 07:36:00	SPY	ETF	108.86	108.86	108.85	108.85	3800.0
2009-10-15 07:37:00	SPY	ETF	108.86	108.86	108.81	108.81	8200.0
2009-10-15 07:38:00	SPY	ETF	108.82	108.82	108.8	108.8	4700.0
2009-10-15 07:39:00	SPY	ETF	108.82	108.87	108.82	108.87	1800.0
2009-10-15 07:40:00	SPY	ETF	108.87	108.89	108.87	108.88	26400.0
2009-10-15 07:41:00	SPY	ETF	108.89	108.92	108.87	108.91	15600.0
2009-10-15 07:42:00	SPY	ETF	108.93	108.93	108.9	108.9	9175.0
2009-10-15 07:43:00	SPY	ETF	108.92	108.92	108.91	108.92	5904.0
2009-10-15 07:44:00	SPY	ETF	108.92	108.92	108.91	108.92	23996.0
2009-10-15 07:45:00	SPY	ETF	108.92	108.93	108.89	108.89	29000.0

> showing 50 of 92,006 rows — these rows as CSV

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