PREVIEW / etf_5min / 2007-11-20

all etf 5-min files

  file:    by_date/etf_5min/2007/2007-11-20.parquet
  size:    459 KB
  rows:    21,245

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
2007-11-20 04:20:00	SPY	ETF	144.34	144.34	144.34	144.34	1000.0
2007-11-20 04:40:00	SPY	ETF	144.54	144.54	144.54	144.54	1000.0
2007-11-20 04:45:00	SPY	ETF	144.49	144.49	144.49	144.49	2000.0
2007-11-20 04:55:00	SPY	ETF	144.66	144.66	144.66	144.66	1000.0
2007-11-20 05:00:00	SPY	ETF	144.59	144.59	144.59	144.59	1000.0
2007-11-20 05:05:00	SPY	ETF	144.58	144.58	144.58	144.58	2000.0
2007-11-20 05:15:00	SPY	ETF	144.68	144.68	144.68	144.68	3000.0
2007-11-20 05:25:00	SPY	ETF	144.69	144.69	144.69	144.69	500.0
2007-11-20 05:30:00	SPY	ETF	144.74	144.76	144.74	144.76	1000.0
2007-11-20 05:35:00	SPY	ETF	144.79	144.79	144.79	144.79	1500.0
2007-11-20 05:50:00	SPY	ETF	144.72	144.72	144.72	144.72	1000.0
2007-11-20 06:00:00	SPY	ETF	144.61	144.61	144.61	144.61	2000.0
2007-11-20 06:20:00	SPY	ETF	144.7	144.7	144.7	144.7	1000.0
2007-11-20 06:25:00	SPY	ETF	144.64	144.64	144.6	144.62	28500.0
2007-11-20 06:30:00	SPY	ETF	144.82	144.82	144.82	144.82	2000.0
2007-11-20 06:35:00	SPY	ETF	144.87	144.87	144.85	144.85	1300.0
2007-11-20 06:40:00	SPY	ETF	144.85	144.85	144.85	144.85	500.0
2007-11-20 06:45:00	SPY	ETF	144.85	144.92	144.85	144.89	7300.0
2007-11-20 06:50:00	SPY	ETF	144.94	145.0	144.94	145.0	8700.0
2007-11-20 06:55:00	SPY	ETF	144.87	144.87	144.87	144.87	15000.0
2007-11-20 07:00:00	SPY	ETF	144.86	144.87	144.74	144.74	60200.0
2007-11-20 07:05:00	SPY	ETF	144.7	144.81	144.68	144.81	82200.0
2007-11-20 07:10:00	SPY	ETF	144.73	144.76	144.72	144.72	31600.0
2007-11-20 07:15:00	SPY	ETF	144.75	144.82	144.74	144.8	165500.0
2007-11-20 07:20:00	SPY	ETF	144.77	144.86	144.77	144.86	281900.0
2007-11-20 07:25:00	SPY	ETF	144.81	144.87	144.79	144.82	177500.0
2007-11-20 07:30:00	SPY	ETF	144.8	144.8	144.55	144.63	108000.0
2007-11-20 07:35:00	SPY	ETF	144.6	144.6	144.37	144.48	496800.0
2007-11-20 07:40:00	SPY	ETF	144.5	144.53	144.29	144.34	234100.0
2007-11-20 07:45:00	SPY	ETF	144.38	144.45	144.27	144.31	178600.0
2007-11-20 07:50:00	SPY	ETF	144.32	144.35	144.12	144.22	243400.0
2007-11-20 07:55:00	SPY	ETF	144.23	144.37	144.2	144.37	158700.0
2007-11-20 08:00:00	SPY	ETF	144.35	144.86	144.2	144.38	235600.0
2007-11-20 08:05:00	SPY	ETF	144.36	144.39	144.32	144.35	528900.0
2007-11-20 08:10:00	SPY	ETF	144.35	144.45	144.35	144.42	187700.0
2007-11-20 08:15:00	SPY	ETF	144.43	144.44	144.37	144.41	114200.0
2007-11-20 08:20:00	SPY	ETF	144.41	144.42	144.31	144.35	245700.0
2007-11-20 08:25:00	SPY	ETF	144.35	144.4	144.29	144.32	330000.0
2007-11-20 08:30:00	SPY	ETF	144.32	144.78	144.04	144.06	2989400.0
2007-11-20 08:35:00	SPY	ETF	144.06	144.17	144.06	144.07	285500.0
2007-11-20 08:40:00	SPY	ETF	144.09	144.16	143.83	143.89	1939300.0
2007-11-20 08:45:00	SPY	ETF	143.9	144.1	143.74	143.88	1429400.0
2007-11-20 08:50:00	SPY	ETF	143.89	143.98	143.8	143.96	321700.0
2007-11-20 08:55:00	SPY	ETF	143.96	143.99	143.87	143.95	238900.0
2007-11-20 09:00:00	SPY	ETF	143.97	144.08	143.97	144.04	210000.0
2007-11-20 09:05:00	SPY	ETF	144.05	144.13	144.03	144.07	322000.0
2007-11-20 09:10:00	SPY	ETF	144.07	144.14	144.05	144.08	464500.0
2007-11-20 09:15:00	SPY	ETF	144.09	144.09	143.81	143.82	515800.0
2007-11-20 09:20:00	SPY	ETF	143.82	143.95	143.74	143.78	867700.0
2007-11-20 09:25:00	SPY	ETF	143.77	143.85	143.6	143.63	1431700.0

> showing 50 of 21,245 rows — these rows as CSV

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