PREVIEW / etf_5min / 2009-12-07

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-12-07.parquet
  size:    694 KB
  rows:    29,918

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-07 04:15:00	SPY	ETF	110.64	110.64	110.64	110.64	200.0
2009-12-07 04:35:00	SPY	ETF	110.8	110.8	110.8	110.8	200.0
2009-12-07 04:45:00	SPY	ETF	110.86	110.86	110.86	110.86	100.0
2009-12-07 04:55:00	SPY	ETF	110.87	110.9	110.87	110.9	220.0
2009-12-07 05:00:00	SPY	ETF	110.94	110.94	110.94	110.94	500.0
2009-12-07 05:05:00	SPY	ETF	110.91	110.91	110.88	110.88	600.0
2009-12-07 05:10:00	SPY	ETF	110.88	110.9	110.88	110.9	4500.0
2009-12-07 05:40:00	SPY	ETF	111.09	111.09	111.09	111.09	100.0
2009-12-07 05:55:00	SPY	ETF	111.0	111.0	110.9	110.9	15500.0
2009-12-07 06:05:00	SPY	ETF	110.98	110.98	110.98	110.98	2500.0
2009-12-07 06:10:00	SPY	ETF	110.99	111.0	110.99	110.99	7500.0
2009-12-07 06:35:00	SPY	ETF	110.98	110.98	110.98	110.98	500.0
2009-12-07 06:55:00	SPY	ETF	110.86	110.86	110.85	110.85	20000.0
2009-12-07 07:05:00	SPY	ETF	110.87	110.87	110.81	110.81	18900.0
2009-12-07 07:10:00	SPY	ETF	110.81	110.85	110.8	110.8	60220.0
2009-12-07 07:15:00	SPY	ETF	110.84	110.87	110.81	110.84	8288.0
2009-12-07 07:20:00	SPY	ETF	110.84	110.91	110.84	110.89	307908.0
2009-12-07 07:25:00	SPY	ETF	110.84	110.84	110.82	110.84	82700.0
2009-12-07 07:30:00	SPY	ETF	110.84	110.9	110.84	110.87	31000.0
2009-12-07 07:35:00	SPY	ETF	110.86	110.89	110.86	110.89	3029.0
2009-12-07 07:40:00	SPY	ETF	110.86	110.97	110.86	110.95	114136.0
2009-12-07 07:45:00	SPY	ETF	110.99	111.1	110.97	111.1	67273.0
2009-12-07 07:50:00	SPY	ETF	111.07	111.09	111.05	111.07	37600.0
2009-12-07 07:55:00	SPY	ETF	111.08	111.1	111.06	111.06	35586.0
2009-12-07 08:00:00	SPY	ETF	111.05	111.07	110.83	111.05	115405.0
2009-12-07 08:05:00	SPY	ETF	111.04	111.04	111.0	111.03	24871.0
2009-12-07 08:10:00	SPY	ETF	111.02	111.06	111.02	111.03	40743.0
2009-12-07 08:15:00	SPY	ETF	111.04	111.04	110.94	110.97	72206.0
2009-12-07 08:20:00	SPY	ETF	110.96	111.03	110.96	111.02	40561.0
2009-12-07 08:25:00	SPY	ETF	111.01	111.01	110.96	110.99	61631.0
2009-12-07 08:30:00	SPY	ETF	110.99	111.02	110.75	111.01	314840.0
2009-12-07 08:35:00	SPY	ETF	111.01	111.03	110.96	111.0	120449.0
2009-12-07 08:40:00	SPY	ETF	111.0	111.02	110.97	111.02	101952.0
2009-12-07 08:45:00	SPY	ETF	111.01	111.08	111.01	111.05	274629.0
2009-12-07 08:50:00	SPY	ETF	111.06	111.07	111.0	111.0	60577.0
2009-12-07 08:55:00	SPY	ETF	111.0	111.02	110.99	111.01	48577.0
2009-12-07 09:00:00	SPY	ETF	111.02	111.07	111.0	111.04	90898.0
2009-12-07 09:05:00	SPY	ETF	111.03	111.04	110.96	110.98	83438.0
2009-12-07 09:10:00	SPY	ETF	110.98	111.01	110.96	110.97	53329.0
2009-12-07 09:15:00	SPY	ETF	110.96	111.0	110.95	110.99	41721.0
2009-12-07 09:20:00	SPY	ETF	110.99	111.0	110.91	110.92	133509.0
2009-12-07 09:25:00	SPY	ETF	110.91	110.96	110.89	110.95	102662.0
2009-12-07 09:30:00	SPY	ETF	110.91	111.16	110.88	111.1204	3466407.0
2009-12-07 09:35:00	SPY	ETF	111.12	111.32	111.08	111.16	3939140.0
2009-12-07 09:40:00	SPY	ETF	111.16	111.23	111.04	111.19	3287585.0
2009-12-07 09:45:00	SPY	ETF	111.2	111.5	111.185	111.5	3747106.0
2009-12-07 09:50:00	SPY	ETF	111.5	111.53	111.37	111.45	2387994.0
2009-12-07 09:55:00	SPY	ETF	111.44	111.475	111.33	111.38	1913576.0
2009-12-07 10:00:00	SPY	ETF	111.39	111.45	111.05	111.08	3862998.0
2009-12-07 10:05:00	SPY	ETF	111.08	111.16	111.0	111.0526	3186541.0

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

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