PREVIEW / etf_5min / 2009-04-13

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-04-13.parquet
  size:    677 KB
  rows:    28,637

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-04-13 04:15:00	SPY	ETF	85.13	85.13	85.1	85.1	847.0
2009-04-13 04:25:00	SPY	ETF	85.09	85.09	85.06	85.06	700.0
2009-04-13 04:30:00	SPY	ETF	85.06	85.06	85.05	85.05	367.0
2009-04-13 05:05:00	SPY	ETF	85.0	85.0	85.0	85.0	100.0
2009-04-13 05:10:00	SPY	ETF	84.96	84.96	84.96	84.96	100.0
2009-04-13 05:20:00	SPY	ETF	84.99	84.99	84.99	84.99	1626.0
2009-04-13 05:45:00	SPY	ETF	85.01	85.01	85.0	85.0	600.0
2009-04-13 05:50:00	SPY	ETF	84.9	84.9	84.9	84.9	500.0
2009-04-13 05:55:00	SPY	ETF	84.88	84.88	84.88	84.88	100.0
2009-04-13 06:00:00	SPY	ETF	84.93	84.93	84.93	84.93	3407.0
2009-04-13 06:10:00	SPY	ETF	84.91	84.91	84.91	84.91	100.0
2009-04-13 06:15:00	SPY	ETF	84.91	84.91	84.9	84.91	800.0
2009-04-13 06:20:00	SPY	ETF	84.91	84.91	84.91	84.91	1200.0
2009-04-13 06:30:00	SPY	ETF	84.93	84.93	84.93	84.93	150.0
2009-04-13 06:40:00	SPY	ETF	84.95	84.95	84.95	84.95	300.0
2009-04-13 06:45:00	SPY	ETF	84.95	84.95	84.94	84.94	4000.0
2009-04-13 06:50:00	SPY	ETF	84.96	84.99	84.96	84.99	300.0
2009-04-13 06:55:00	SPY	ETF	85.08	85.08	85.02	85.02	3500.0
2009-04-13 07:00:00	SPY	ETF	85.05	85.16	85.03	85.12	28142.0
2009-04-13 07:05:00	SPY	ETF	85.08	85.11	85.08	85.1	5700.0
2009-04-13 07:10:00	SPY	ETF	85.15	85.22	85.15	85.2	21200.0
2009-04-13 07:15:00	SPY	ETF	85.2	85.21	85.1	85.15	24430.0
2009-04-13 07:20:00	SPY	ETF	85.15	85.19	85.1	85.12	42750.0
2009-04-13 07:25:00	SPY	ETF	85.12	85.14	85.05	85.05	14974.0
2009-04-13 07:30:00	SPY	ETF	85.08	85.09	85.06	85.09	88395.0
2009-04-13 07:35:00	SPY	ETF	85.06	85.09	85.05	85.07	24869.0
2009-04-13 07:40:00	SPY	ETF	85.06	85.06	84.97	84.97	56777.0
2009-04-13 07:45:00	SPY	ETF	84.98	85.0	84.93	84.94	48869.0
2009-04-13 07:50:00	SPY	ETF	84.94	85.02	84.94	84.96	46069.0
2009-04-13 07:55:00	SPY	ETF	84.97	84.98	84.95	84.97	20503.0
2009-04-13 08:00:00	SPY	ETF	84.98	85.0	84.96	85.0	22930.0
2009-04-13 08:05:00	SPY	ETF	84.98	85.08	84.98	85.07	49316.0
2009-04-13 08:10:00	SPY	ETF	85.07	85.07	85.01	85.01	43279.0
2009-04-13 08:15:00	SPY	ETF	85.02	85.06	85.02	85.04	32273.0
2009-04-13 08:20:00	SPY	ETF	85.05	85.17	85.05	85.17	65708.0
2009-04-13 08:25:00	SPY	ETF	85.17	85.19	85.15	85.16	160000.0
2009-04-13 08:30:00	SPY	ETF	85.16	85.182	85.13	85.15	261044.0
2009-04-13 08:35:00	SPY	ETF	85.15	85.19	85.15	85.18	56717.0
2009-04-13 08:40:00	SPY	ETF	85.18	85.21	85.17	85.2	51490.0
2009-04-13 08:45:00	SPY	ETF	85.2	85.2	85.17	85.19	46339.0
2009-04-13 08:50:00	SPY	ETF	85.2	85.25	85.17	85.17	98704.0
2009-04-13 08:55:00	SPY	ETF	85.18	85.19	85.16	85.16	207701.0
2009-04-13 09:00:00	SPY	ETF	85.17	85.17	85.09	85.12	51797.0
2009-04-13 09:05:00	SPY	ETF	85.12	85.12	85.04	85.04	359359.0
2009-04-13 09:10:00	SPY	ETF	85.05	85.08	84.99	85.04	204169.0
2009-04-13 09:15:00	SPY	ETF	85.04	85.07	84.97	85.0	505374.0
2009-04-13 09:20:00	SPY	ETF	84.99	84.99	84.93	84.94	392684.0
2009-04-13 09:25:00	SPY	ETF	84.93	84.96	84.89	84.92	439039.0
2009-04-13 09:30:00	SPY	ETF	84.92	85.04	84.85	84.85	5087866.0
2009-04-13 09:35:00	SPY	ETF	84.86	85.0	84.82	84.96	3411890.0

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

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