PREVIEW / etf_5min / 2012-10-23

all etf 5-min files

  file:    by_date/etf_5min/2012/2012-10-23.parquet
  size:    932 KB
  rows:    38,818

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-10-23 04:00:00	SPY	ETF	142.71	142.71	142.54	142.69	1265.0
2012-10-23 04:05:00	SPY	ETF	142.63	142.63	142.54	142.56	31109.0
2012-10-23 04:10:00	SPY	ETF	142.57	142.57	142.54	142.57	1075.0
2012-10-23 04:15:00	SPY	ETF	142.66	142.66	142.66	142.66	100.0
2012-10-23 04:20:00	SPY	ETF	142.65	142.65	142.65	142.65	100.0
2012-10-23 04:30:00	SPY	ETF	142.66	142.66	142.66	142.66	100.0
2012-10-23 04:35:00	SPY	ETF	142.58	142.58	142.58	142.58	200.0
2012-10-23 04:50:00	SPY	ETF	142.63	142.63	142.63	142.63	300.0
2012-10-23 05:05:00	SPY	ETF	142.51	142.51	142.49	142.49	1100.0
2012-10-23 05:10:00	SPY	ETF	142.5	142.5	142.5	142.5	11500.0
2012-10-23 05:15:00	SPY	ETF	142.65	142.68	142.65	142.68	14000.0
2012-10-23 05:20:00	SPY	ETF	142.71	142.75	142.71	142.75	5100.0
2012-10-23 05:30:00	SPY	ETF	142.64	142.64	142.63	142.63	6000.0
2012-10-23 05:40:00	SPY	ETF	142.6	142.6	142.55	142.55	7650.0
2012-10-23 05:45:00	SPY	ETF	142.55	142.55	142.49	142.49	1300.0
2012-10-23 05:50:00	SPY	ETF	142.47	142.7	142.47	142.7	39008.0
2012-10-23 06:00:00	SPY	ETF	142.68	142.71	142.62	142.62	31059.0
2012-10-23 06:05:00	SPY	ETF	142.59	142.59	142.54	142.58	1370.0
2012-10-23 06:10:00	SPY	ETF	142.59	142.59	142.45	142.45	16650.0
2012-10-23 06:15:00	SPY	ETF	142.49	142.49	142.44	142.44	300.0
2012-10-23 06:20:00	SPY	ETF	142.45	142.49	142.45	142.49	1500.0
2012-10-23 06:25:00	SPY	ETF	142.49	142.49	142.49	142.49	200.0
2012-10-23 06:30:00	SPY	ETF	142.45	142.45	142.37	142.4	37793.0
2012-10-23 06:35:00	SPY	ETF	142.35	142.35	142.17	142.27	94520.0
2012-10-23 06:40:00	SPY	ETF	142.26	142.26	142.23	142.25	17700.0
2012-10-23 06:45:00	SPY	ETF	142.23	142.23	141.35	141.98	236494.0
2012-10-23 06:50:00	SPY	ETF	141.97	142.1	141.97	142.05	4280.0
2012-10-23 06:55:00	SPY	ETF	142.08	142.1	141.94	141.94	15896.0
2012-10-23 07:00:00	SPY	ETF	141.95	142.16	141.94	142.1	89220.0
2012-10-23 07:05:00	SPY	ETF	142.08	142.11	142.03	142.1	70795.0
2012-10-23 07:10:00	SPY	ETF	142.11	142.16	142.09	142.16	80930.0
2012-10-23 07:15:00	SPY	ETF	142.16	142.16	142.07	142.12	37605.0
2012-10-23 07:20:00	SPY	ETF	142.11	142.12	142.07	142.1	106955.0
2012-10-23 07:25:00	SPY	ETF	142.1	142.15	142.05	142.15	45562.0
2012-10-23 07:30:00	SPY	ETF	142.17	142.25	142.14	142.23	177945.0
2012-10-23 07:35:00	SPY	ETF	142.25	142.26	142.17	142.17	55187.0
2012-10-23 07:40:00	SPY	ETF	142.2	142.2	142.05	142.1	41545.0
2012-10-23 07:45:00	SPY	ETF	142.08	142.12	142.02	142.02	144805.0
2012-10-23 07:50:00	SPY	ETF	142.06	142.11	142.01	142.08	62297.0
2012-10-23 07:55:00	SPY	ETF	142.1	142.11	142.05	142.09	10285.0
2012-10-23 08:00:00	SPY	ETF	142.1	142.175	142.03	142.03	251605.0
2012-10-23 08:05:00	SPY	ETF	142.02	142.03	141.93	141.94	133231.0
2012-10-23 08:10:00	SPY	ETF	141.94	142.04	141.94	142.03	314615.0
2012-10-23 08:15:00	SPY	ETF	142.03	142.05	141.96	141.98	250806.0
2012-10-23 08:20:00	SPY	ETF	141.97	142.04	141.96	142.02	86462.0
2012-10-23 08:25:00	SPY	ETF	142.03	142.04	141.86	141.89	153779.0
2012-10-23 08:30:00	SPY	ETF	141.89	141.9	141.73	141.82	340076.0
2012-10-23 08:35:00	SPY	ETF	141.82	141.89	141.8	141.86	229288.0
2012-10-23 08:40:00	SPY	ETF	141.87	143.41	141.73	141.8	432162.0
2012-10-23 08:45:00	SPY	ETF	141.81	141.83	141.71	141.81	138328.0

> showing 50 of 38,818 rows — these rows as CSV

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