PREVIEW / etf_5min / 2009-07-13

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-07-13.parquet
  size:    684 KB
  rows:    28,356

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-07-13 04:40:00	SPY	ETF	87.75	87.96	87.6	87.6	1200.0
2009-07-13 04:45:00	SPY	ETF	87.61	87.61	87.57	87.57	500.0
2009-07-13 04:55:00	SPY	ETF	87.58	87.58	87.57	87.57	400.0
2009-07-13 05:00:00	SPY	ETF	87.59	87.59	87.59	87.59	200.0
2009-07-13 05:05:00	SPY	ETF	87.55	87.55	87.51	87.52	600.0
2009-07-13 05:10:00	SPY	ETF	87.52	87.52	87.44	87.49	600.0
2009-07-13 05:20:00	SPY	ETF	87.52	87.52	87.52	87.52	10000.0
2009-07-13 05:25:00	SPY	ETF	87.52	87.52	87.52	87.52	5000.0
2009-07-13 05:30:00	SPY	ETF	87.5	87.5	87.47	87.48	600.0
2009-07-13 05:35:00	SPY	ETF	87.44	87.44	87.39	87.42	1100.0
2009-07-13 06:00:00	SPY	ETF	87.34	87.34	87.31	87.31	400.0
2009-07-13 06:05:00	SPY	ETF	87.34	87.34	87.34	87.34	300.0
2009-07-13 06:10:00	SPY	ETF	87.43	87.43	87.43	87.43	9700.0
2009-07-13 06:15:00	SPY	ETF	87.5	87.5	87.5	87.5	900.0
2009-07-13 06:20:00	SPY	ETF	87.58	87.62	87.58	87.62	11000.0
2009-07-13 06:25:00	SPY	ETF	87.63	87.63	87.63	87.63	3000.0
2009-07-13 06:30:00	SPY	ETF	87.55	87.55	87.55	87.55	13200.0
2009-07-13 06:35:00	SPY	ETF	87.6	87.6	87.6	87.6	6300.0
2009-07-13 06:40:00	SPY	ETF	87.8	87.8	87.8	87.8	3000.0
2009-07-13 06:45:00	SPY	ETF	87.78	87.9	87.78	87.84	9200.0
2009-07-13 06:50:00	SPY	ETF	87.87	87.87	87.87	87.87	300.0
2009-07-13 07:00:00	SPY	ETF	87.93	87.98	87.92	87.93	9200.0
2009-07-13 07:05:00	SPY	ETF	87.87	87.87	87.78	87.8	4800.0
2009-07-13 07:10:00	SPY	ETF	87.8	87.8	87.59	87.59	6800.0
2009-07-13 07:15:00	SPY	ETF	87.6	87.72	87.6	87.72	12128.0
2009-07-13 07:20:00	SPY	ETF	87.72	87.78	87.7	87.77	31300.0
2009-07-13 07:25:00	SPY	ETF	87.8	87.86	87.74	87.74	71075.0
2009-07-13 07:30:00	SPY	ETF	87.75	87.78	87.64	87.7	41475.0
2009-07-13 07:35:00	SPY	ETF	87.72	87.82	87.71	87.82	13675.0
2009-07-13 07:40:00	SPY	ETF	87.84	87.88	87.84	87.86	25999.0
2009-07-13 07:45:00	SPY	ETF	87.87	87.98	87.87	87.98	55000.0
2009-07-13 07:50:00	SPY	ETF	87.99	88.02	87.94	88.02	35700.0
2009-07-13 07:55:00	SPY	ETF	88.02	88.02	87.97	88.01	38400.0
2009-07-13 08:00:00	SPY	ETF	87.99	88.02	87.24	88.0	372246.0
2009-07-13 08:05:00	SPY	ETF	87.99	88.12	87.99	88.12	72299.0
2009-07-13 08:10:00	SPY	ETF	88.12	88.21	88.11	88.19	119500.0
2009-07-13 08:15:00	SPY	ETF	88.18	88.21	88.15	88.19	140368.0
2009-07-13 08:20:00	SPY	ETF	88.19	88.25	88.16	88.25	505951.0
2009-07-13 08:25:00	SPY	ETF	88.26	88.4	88.26	88.34	217934.0
2009-07-13 08:30:00	SPY	ETF	88.35	88.4	88.34	88.4	215102.0
2009-07-13 08:35:00	SPY	ETF	88.4	88.54	88.38	88.52	643658.0
2009-07-13 08:40:00	SPY	ETF	88.53	88.63	88.49	88.54	220426.0
2009-07-13 08:45:00	SPY	ETF	88.54	88.57	88.42	88.44	140376.0
2009-07-13 08:50:00	SPY	ETF	88.44	88.44	88.39	88.39	343620.0
2009-07-13 08:55:00	SPY	ETF	88.39	88.48	88.37	88.48	269104.0
2009-07-13 09:00:00	SPY	ETF	88.47	88.58	88.42	88.56	179723.0
2009-07-13 09:05:00	SPY	ETF	88.55	88.55	88.35	88.37	338877.0
2009-07-13 09:10:00	SPY	ETF	88.38	88.38	88.29	88.33	268223.0
2009-07-13 09:15:00	SPY	ETF	88.33	88.4	88.29	88.3	169071.0
2009-07-13 09:20:00	SPY	ETF	88.3	88.35	88.25	88.27	147909.0

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

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