PREVIEW / etf_5min / 2009-10-21

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-10-21.parquet
  size:    764 KB
  rows:    31,361

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-21 04:25:00	SPY	ETF	109.05	109.05	109.05	109.05	700.0
2009-10-21 04:30:00	SPY	ETF	109.0	109.0	109.0	109.0	100.0
2009-10-21 04:40:00	SPY	ETF	109.1	109.15	109.1	109.15	300.0
2009-10-21 04:55:00	SPY	ETF	109.25	109.25	109.25	109.25	100.0
2009-10-21 05:05:00	SPY	ETF	109.15	109.15	109.11	109.11	2100.0
2009-10-21 05:15:00	SPY	ETF	108.95	108.95	108.88	108.88	700.0
2009-10-21 05:20:00	SPY	ETF	108.88	108.88	108.88	108.88	200.0
2009-10-21 05:25:00	SPY	ETF	108.92	108.92	108.92	108.92	2169.0
2009-10-21 05:40:00	SPY	ETF	108.75	108.75	108.75	108.75	100.0
2009-10-21 05:45:00	SPY	ETF	108.73	108.75	108.73	108.75	200.0
2009-10-21 05:50:00	SPY	ETF	108.73	108.73	108.73	108.73	100.0
2009-10-21 06:00:00	SPY	ETF	108.87	108.87	108.87	108.87	100.0
2009-10-21 06:10:00	SPY	ETF	108.9	108.9	108.9	108.9	15000.0
2009-10-21 06:15:00	SPY	ETF	108.76	108.78	108.68	108.68	1000.0
2009-10-21 06:20:00	SPY	ETF	108.82	108.85	108.82	108.84	31218.0
2009-10-21 06:25:00	SPY	ETF	108.87	108.87	108.8	108.8	300.0
2009-10-21 06:35:00	SPY	ETF	108.87	108.87	108.87	108.87	650.0
2009-10-21 06:45:00	SPY	ETF	108.87	108.87	108.87	108.87	2000.0
2009-10-21 06:50:00	SPY	ETF	108.91	108.91	108.84	108.84	3500.0
2009-10-21 06:55:00	SPY	ETF	108.84	108.84	108.84	108.84	100.0
2009-10-21 07:00:00	SPY	ETF	108.86	108.86	108.78	108.78	16289.0
2009-10-21 07:05:00	SPY	ETF	108.79	108.79	108.76	108.77	4800.0
2009-10-21 07:10:00	SPY	ETF	108.75	108.77	108.75	108.76	50800.0
2009-10-21 07:15:00	SPY	ETF	108.77	108.8	108.75	108.8	52700.0
2009-10-21 07:20:00	SPY	ETF	108.78	108.82	108.76	108.81	63050.0
2009-10-21 07:25:00	SPY	ETF	108.81	108.81	108.78	108.81	69450.0
2009-10-21 07:30:00	SPY	ETF	108.78	108.81	108.7	108.7	131400.0
2009-10-21 07:35:00	SPY	ETF	108.71	108.79	108.7	108.75	47207.0
2009-10-21 07:40:00	SPY	ETF	108.77	108.79	108.56	108.64	48228.0
2009-10-21 07:45:00	SPY	ETF	108.65	108.72	108.59	108.72	40955.0
2009-10-21 07:50:00	SPY	ETF	108.7	108.75	108.65	108.73	105155.0
2009-10-21 07:55:00	SPY	ETF	108.76	108.78	108.73	108.77	149304.0
2009-10-21 08:00:00	SPY	ETF	108.77	109.05	108.67	108.9	982817.0
2009-10-21 08:05:00	SPY	ETF	108.9	108.9	108.82	108.85	485136.0
2009-10-21 08:10:00	SPY	ETF	108.85	108.94	108.82	108.92	182549.0
2009-10-21 08:15:00	SPY	ETF	108.91	108.93	108.82	108.84	331665.0
2009-10-21 08:20:00	SPY	ETF	108.84	108.89	108.84	108.89	96355.0
2009-10-21 08:25:00	SPY	ETF	108.89	109.04	108.88	109.02	253402.0
2009-10-21 08:30:00	SPY	ETF	109.03	109.04	108.95	108.99	233768.0
2009-10-21 08:35:00	SPY	ETF	108.99	109.1	108.97	108.99	437935.0
2009-10-21 08:40:00	SPY	ETF	108.98	108.99	108.85	108.91	545916.0
2009-10-21 08:45:00	SPY	ETF	108.91	108.99	108.9	108.96	154600.0
2009-10-21 08:50:00	SPY	ETF	108.96	109.01	108.95	108.98	104121.0
2009-10-21 08:55:00	SPY	ETF	108.98	109.01	108.94	109.0	86761.0
2009-10-21 09:00:00	SPY	ETF	109.0	109.02	109.0	109.0	58900.0
2009-10-21 09:05:00	SPY	ETF	109.0	109.03	108.99	109.0	95741.0
2009-10-21 09:10:00	SPY	ETF	109.01	109.02	108.98	109.01	161651.0
2009-10-21 09:15:00	SPY	ETF	109.0	109.0	108.97	108.97	103201.0
2009-10-21 09:20:00	SPY	ETF	108.96	109.02	108.95	109.02	62751.0
2009-10-21 09:25:00	SPY	ETF	109.0	109.05	109.0	109.04	236183.0

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

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