PREVIEW / etf_5min / 2009-05-22

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-05-22.parquet
  size:    653 KB
  rows:    28,876

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-05-22 04:15:00	SPY	ETF	89.69	89.7	89.69	89.7	600.0
2009-05-22 04:20:00	SPY	ETF	89.84	89.84	89.84	89.84	100.0
2009-05-22 04:25:00	SPY	ETF	89.82	89.82	89.75	89.8	2000.0
2009-05-22 04:30:00	SPY	ETF	89.84	89.9	89.84	89.9	3400.0
2009-05-22 04:35:00	SPY	ETF	89.94	89.99	89.94	89.99	1400.0
2009-05-22 04:45:00	SPY	ETF	89.87	89.89	89.87	89.89	800.0
2009-05-22 04:55:00	SPY	ETF	89.9	89.9	89.9	89.9	400.0
2009-05-22 05:20:00	SPY	ETF	89.96	89.96	89.96	89.96	400.0
2009-05-22 05:30:00	SPY	ETF	89.94	89.94	89.94	89.94	2600.0
2009-05-22 05:35:00	SPY	ETF	89.96	90.02	89.96	90.02	2200.0
2009-05-22 06:00:00	SPY	ETF	90.02	90.02	89.97	89.97	710.0
2009-05-22 06:05:00	SPY	ETF	90.02	90.02	89.97	89.97	710.0
2009-05-22 06:10:00	SPY	ETF	89.97	89.97	89.97	89.97	480.0
2009-05-22 06:25:00	SPY	ETF	89.97	89.97	89.97	89.97	200.0
2009-05-22 06:30:00	SPY	ETF	90.02	90.02	89.94	89.94	20500.0
2009-05-22 06:40:00	SPY	ETF	89.92	89.95	89.92	89.94	3000.0
2009-05-22 06:45:00	SPY	ETF	89.91	89.99	89.9	89.99	11700.0
2009-05-22 06:50:00	SPY	ETF	89.96	90.0	89.96	90.0	15300.0
2009-05-22 06:55:00	SPY	ETF	89.95	89.95	89.92	89.92	1200.0
2009-05-22 07:00:00	SPY	ETF	89.95	89.99	89.92	89.95	4600.0
2009-05-22 07:05:00	SPY	ETF	89.95	89.97	89.92	89.92	46577.0
2009-05-22 07:10:00	SPY	ETF	89.93	89.93	89.89	89.89	14807.0
2009-05-22 07:15:00	SPY	ETF	89.89	89.95	89.8	89.8	8846.0
2009-05-22 07:20:00	SPY	ETF	89.8	89.88	89.77	89.88	56724.0
2009-05-22 07:25:00	SPY	ETF	89.84	89.86	89.82	89.82	5551.0
2009-05-22 07:30:00	SPY	ETF	89.87	89.87	89.82	89.83	69531.0
2009-05-22 07:35:00	SPY	ETF	89.83	89.83	89.7	89.71	88204.0
2009-05-22 07:40:00	SPY	ETF	89.73	89.77	89.71	89.73	72992.0
2009-05-22 07:45:00	SPY	ETF	89.73	89.77	89.63	89.67	136801.0
2009-05-22 07:50:00	SPY	ETF	89.65	89.68	89.62	89.66	34212.0
2009-05-22 07:55:00	SPY	ETF	89.66	89.75	89.66	89.68	64175.0
2009-05-22 08:00:00	SPY	ETF	89.933	89.933	89.61	89.63	445933.0
2009-05-22 08:05:00	SPY	ETF	89.65	89.72	89.61	89.7	61973.0
2009-05-22 08:10:00	SPY	ETF	89.71	89.8	89.7	89.77	78966.0
2009-05-22 08:15:00	SPY	ETF	89.76	89.85	89.75	89.83	151214.0
2009-05-22 08:20:00	SPY	ETF	89.84	89.99	89.84	89.86	186008.0
2009-05-22 08:25:00	SPY	ETF	89.86	89.95	89.85	89.95	97135.0
2009-05-22 08:30:00	SPY	ETF	89.95	89.95	89.92	89.93	124984.0
2009-05-22 08:35:00	SPY	ETF	89.93	89.93	89.86	89.86	33800.0
2009-05-22 08:40:00	SPY	ETF	89.86	89.87	89.8	89.8	36437.0
2009-05-22 08:45:00	SPY	ETF	89.81	89.84	89.8	89.82	15399.0
2009-05-22 08:50:00	SPY	ETF	89.82	89.85	89.78	89.78	65214.0
2009-05-22 08:55:00	SPY	ETF	89.79	89.79	89.71	89.71	258460.0
2009-05-22 09:00:00	SPY	ETF	89.71	89.73	89.54	89.57	301187.0
2009-05-22 09:05:00	SPY	ETF	89.58	89.62	89.52	89.54	135713.0
2009-05-22 09:10:00	SPY	ETF	89.54	89.57	89.38	89.4	487578.0
2009-05-22 09:15:00	SPY	ETF	89.4	89.44	89.34	89.41	371819.0
2009-05-22 09:20:00	SPY	ETF	89.41	89.41	89.34	89.41	155494.0
2009-05-22 09:25:00	SPY	ETF	89.41	89.45	89.39	89.44	216589.0
2009-05-22 09:30:00	SPY	ETF	89.46	89.54	89.31	89.38	3013896.0

> showing 50 of 28,876 rows — these rows as CSV

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