PREVIEW / etf_5min / 2009-09-01

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-09-01.parquet
  size:    778 KB
  rows:    31,875

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-09-01 04:10:00	SPY	ETF	102.47	102.47	102.35	102.35	3000.0
2009-09-01 04:15:00	SPY	ETF	102.05	102.05	102.01	102.01	700.0
2009-09-01 04:20:00	SPY	ETF	102.02	102.1	102.02	102.1	700.0
2009-09-01 04:25:00	SPY	ETF	102.05	102.05	101.89	101.89	800.0
2009-09-01 04:30:00	SPY	ETF	101.76	101.76	101.67	101.67	700.0
2009-09-01 04:35:00	SPY	ETF	101.83	101.83	101.83	101.83	100.0
2009-09-01 04:45:00	SPY	ETF	101.77	101.77	101.77	101.77	100.0
2009-09-01 04:55:00	SPY	ETF	101.86	101.9	101.86	101.9	5300.0
2009-09-01 05:05:00	SPY	ETF	101.82	101.82	101.82	101.82	100.0
2009-09-01 05:10:00	SPY	ETF	101.85	101.85	101.85	101.85	100.0
2009-09-01 05:20:00	SPY	ETF	101.75	101.75	101.75	101.75	10000.0
2009-09-01 05:25:00	SPY	ETF	101.75	101.75	101.75	101.75	10100.0
2009-09-01 05:30:00	SPY	ETF	101.6	101.63	101.6	101.63	315.0
2009-09-01 05:55:00	SPY	ETF	101.81	101.81	101.81	101.81	1000.0
2009-09-01 06:00:00	SPY	ETF	101.75	101.75	101.75	101.75	400.0
2009-09-01 06:10:00	SPY	ETF	101.7	101.76	101.7	101.76	400.0
2009-09-01 06:25:00	SPY	ETF	101.75	101.75	101.75	101.75	100.0
2009-09-01 06:30:00	SPY	ETF	101.69	101.69	101.68	101.68	350.0
2009-09-01 06:35:00	SPY	ETF	101.7	101.7	101.65	101.65	700.0
2009-09-01 06:45:00	SPY	ETF	101.7	101.7	101.68	101.68	400.0
2009-09-01 06:50:00	SPY	ETF	101.65	101.7	101.65	101.7	600.0
2009-09-01 07:00:00	SPY	ETF	101.69	101.7	101.63	101.69	8618.0
2009-09-01 07:05:00	SPY	ETF	101.69	101.75	101.69	101.75	60000.0
2009-09-01 07:10:00	SPY	ETF	101.75	101.81	101.75	101.81	51500.0
2009-09-01 07:15:00	SPY	ETF	101.8	101.81	101.75	101.78	84000.0
2009-09-01 07:20:00	SPY	ETF	101.78	101.85	101.78	101.84	20650.0
2009-09-01 07:25:00	SPY	ETF	101.83	101.85	101.81	101.83	27350.0
2009-09-01 07:30:00	SPY	ETF	101.83	101.93	101.83	101.93	57100.0
2009-09-01 07:35:00	SPY	ETF	101.95	101.95	101.91	101.91	25100.0
2009-09-01 07:40:00	SPY	ETF	101.94	101.94	101.9	101.91	130100.0
2009-09-01 07:45:00	SPY	ETF	101.9	101.95	101.9	101.94	80200.0
2009-09-01 07:50:00	SPY	ETF	101.9	101.95	101.9	101.93	102695.0
2009-09-01 07:55:00	SPY	ETF	101.92	101.96	101.9	101.96	109374.0
2009-09-01 08:00:00	SPY	ETF	101.96	102.46	101.93	101.95	1136982.0
2009-09-01 08:05:00	SPY	ETF	101.95	102.0	101.95	101.98	138874.0
2009-09-01 08:10:00	SPY	ETF	101.99	102.09	101.97	102.06	465300.0
2009-09-01 08:15:00	SPY	ETF	102.06	102.09	102.05	102.09	180931.0
2009-09-01 08:20:00	SPY	ETF	102.09	102.1	101.99	102.03	188290.0
2009-09-01 08:25:00	SPY	ETF	102.03	102.03	101.99	102.02	161876.0
2009-09-01 08:30:00	SPY	ETF	102.02	102.04	101.98	102.0	141348.0
2009-09-01 08:35:00	SPY	ETF	102.0	102.03	101.85	101.9	464955.0
2009-09-01 08:40:00	SPY	ETF	101.91	101.99	101.88	101.97	304574.0
2009-09-01 08:45:00	SPY	ETF	101.97	102.04	101.93	102.03	123126.0
2009-09-01 08:50:00	SPY	ETF	102.03	102.05	101.99	101.99	178101.0
2009-09-01 08:55:00	SPY	ETF	101.99	102.01	101.94	101.96	426848.0
2009-09-01 09:00:00	SPY	ETF	101.97	102.0	101.94	101.99	131439.0
2009-09-01 09:05:00	SPY	ETF	102.0	102.01	101.9	101.92	141860.0
2009-09-01 09:10:00	SPY	ETF	101.92	101.92	101.83	101.86	152294.0
2009-09-01 09:15:00	SPY	ETF	101.86	101.97	101.86	101.97	247350.0
2009-09-01 09:20:00	SPY	ETF	101.97	102.01	101.95	101.96	227443.0

> showing 50 of 31,875 rows — these rows as CSV

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