PREVIEW / etf_5min / 2012-11-02

all etf 5-min files

  file:    by_date/etf_5min/2012/2012-11-02.parquet
  size:    869 KB
  rows:    35,606

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
2012-11-02 04:20:00	SPY	ETF	142.82	142.82	142.82	142.82	2500.0
2012-11-02 04:30:00	SPY	ETF	142.86	142.86	142.81	142.81	25500.0
2012-11-02 04:45:00	SPY	ETF	142.73	142.73	142.73	142.73	100.0
2012-11-02 04:55:00	SPY	ETF	142.78	142.78	142.69	142.69	340.0
2012-11-02 05:00:00	SPY	ETF	142.74	142.74	142.74	142.74	800.0
2012-11-02 05:05:00	SPY	ETF	142.68	142.68	142.68	142.68	200.0
2012-11-02 05:20:00	SPY	ETF	142.76	142.76	142.76	142.76	100.0
2012-11-02 05:45:00	SPY	ETF	142.76	142.76	142.76	142.76	100.0
2012-11-02 06:05:00	SPY	ETF	142.93	142.93	142.93	142.93	200.0
2012-11-02 06:20:00	SPY	ETF	142.98	142.98	142.98	142.98	500.0
2012-11-02 06:50:00	SPY	ETF	142.96	142.96	142.96	142.96	500.0
2012-11-02 07:05:00	SPY	ETF	142.98	142.98	142.95	142.95	600.0
2012-11-02 07:10:00	SPY	ETF	142.96	142.96	142.95	142.95	20100.0
2012-11-02 07:20:00	SPY	ETF	142.97	143.0	142.92	143.0	6280.0
2012-11-02 07:25:00	SPY	ETF	142.98	143.01	142.98	143.01	10700.0
2012-11-02 07:30:00	SPY	ETF	142.97	142.97	142.97	142.97	300.0
2012-11-02 07:35:00	SPY	ETF	142.97	142.99	142.96	142.99	2500.0
2012-11-02 07:40:00	SPY	ETF	143.0	143.01	143.0	143.0	7775.0
2012-11-02 07:45:00	SPY	ETF	142.99	142.99	142.99	142.99	10200.0
2012-11-02 07:50:00	SPY	ETF	142.98	143.0	142.94	142.94	28425.0
2012-11-02 07:55:00	SPY	ETF	142.98	142.98	142.94	142.94	11100.0
2012-11-02 08:00:00	SPY	ETF	142.94	142.99	142.92	142.93	8075.0
2012-11-02 08:05:00	SPY	ETF	142.9	142.97	142.81	142.87	330580.0
2012-11-02 08:10:00	SPY	ETF	142.86	142.87	142.81	142.81	11525.0
2012-11-02 08:15:00	SPY	ETF	142.87	142.92	142.85	142.92	74650.0
2012-11-02 08:20:00	SPY	ETF	142.9	142.96	142.9	142.92	40912.0
2012-11-02 08:25:00	SPY	ETF	142.91	143.13	142.9	142.95	147146.0
2012-11-02 08:30:00	SPY	ETF	142.94	143.67	142.8	143.51	2026823.0
2012-11-02 08:35:00	SPY	ETF	143.52	143.55	143.28	143.31	1207948.0
2012-11-02 08:40:00	SPY	ETF	143.3	143.53	143.3	143.52	278385.0
2012-11-02 08:45:00	SPY	ETF	143.54	143.66	143.48	143.62	680841.0
2012-11-02 08:50:00	SPY	ETF	143.63	143.76	143.63	143.75	243263.0
2012-11-02 08:55:00	SPY	ETF	143.75	143.76	143.6	143.63	81944.0
2012-11-02 09:00:00	SPY	ETF	143.62	143.7	143.6	143.61	278662.0
2012-11-02 09:05:00	SPY	ETF	143.6	143.61	143.53	143.58	100143.0
2012-11-02 09:10:00	SPY	ETF	143.58	143.59	143.48	143.51	169147.0
2012-11-02 09:15:00	SPY	ETF	143.5	143.57	143.5	143.515	39383.0
2012-11-02 09:20:00	SPY	ETF	143.52	143.59	143.52	143.55	37531.0
2012-11-02 09:25:00	SPY	ETF	143.55	143.74	143.53	143.68	209741.0
2012-11-02 09:30:00	SPY	ETF	143.68	143.72	143.33	143.39	3166031.0
2012-11-02 09:35:00	SPY	ETF	143.39	143.53	143.37	143.43	1853702.0
2012-11-02 09:40:00	SPY	ETF	143.43	143.435	143.23	143.2401	1887101.0
2012-11-02 09:45:00	SPY	ETF	143.25	143.29	143.07	143.13	1890662.0
2012-11-02 09:50:00	SPY	ETF	143.1299	143.2	143.0	143.185	2542442.0
2012-11-02 09:55:00	SPY	ETF	143.18	143.25	143.12	143.21	1359712.0
2012-11-02 10:00:00	SPY	ETF	143.2	143.25	143.05	143.07	1524689.0
2012-11-02 10:05:00	SPY	ETF	143.06	143.09	142.91	143.07	3834760.0
2012-11-02 10:10:00	SPY	ETF	143.065	143.1647	142.84	142.895	1867911.0
2012-11-02 10:15:00	SPY	ETF	142.89	142.96	142.79	142.9	1378853.0
2012-11-02 10:20:00	SPY	ETF	142.895	142.9	142.58	142.688	1870371.0

> showing 50 of 35,606 rows — these rows as CSV

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