PREVIEW / stock_5min / 2018-03-07

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-03-07.parquet
  size:    5.6 MB
  rows:    362,317
  symbols: 2,860

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
2018-03-07 04:00:00	AAPL	Stock	43.75	43.75	43.675	43.675	20164.0
2018-03-07 04:10:00	AAPL	Stock	43.74	43.745	43.6775	43.6775	25648.0
2018-03-07 04:40:00	AAPL	Stock	43.65	43.65	43.65	43.65	400.0
2018-03-07 04:50:00	AAPL	Stock	43.695	43.7475	43.695	43.7	2148.0
2018-03-07 04:55:00	AAPL	Stock	43.75	43.75	43.75	43.75	5600.0
2018-03-07 05:05:00	AAPL	Stock	43.7475	43.75	43.7475	43.75	5200.0
2018-03-07 05:15:00	AAPL	Stock	43.77	43.77	43.77	43.77	2000.0
2018-03-07 05:20:00	AAPL	Stock	43.815	43.815	43.8125	43.8125	9428.0
2018-03-07 05:35:00	AAPL	Stock	43.7575	43.78	43.7525	43.7525	1200.0
2018-03-07 05:55:00	AAPL	Stock	43.755	43.755	43.75	43.75	8364.0
2018-03-07 06:00:00	AAPL	Stock	43.75	43.75	43.75	43.75	800.0
2018-03-07 06:05:00	AAPL	Stock	43.75	43.75	43.7125	43.7125	3464.0
2018-03-07 06:10:00	AAPL	Stock	43.7075	43.7125	43.69	43.7125	13284.0
2018-03-07 06:15:00	AAPL	Stock	43.675	43.675	43.6525	43.6625	10408.0
2018-03-07 06:25:00	AAPL	Stock	43.6725	43.6725	43.6625	43.6625	9632.0
2018-03-07 06:30:00	AAPL	Stock	43.675	43.675	43.675	43.675	1864.0
2018-03-07 06:35:00	AAPL	Stock	43.6825	43.6825	43.675	43.675	10548.0
2018-03-07 06:45:00	AAPL	Stock	43.7125	43.7125	43.7025	43.7025	800.0
2018-03-07 07:00:00	AAPL	Stock	43.7225	43.84	43.7125	43.75	67696.0
2018-03-07 07:05:00	AAPL	Stock	43.7375	43.775	43.7375	43.74	15944.0
2018-03-07 07:10:00	AAPL	Stock	43.7725	43.81	43.7725	43.795	19592.0
2018-03-07 07:15:00	AAPL	Stock	43.795	43.8125	43.775	43.79	95992.0
2018-03-07 07:20:00	AAPL	Stock	43.7925	43.8025	43.75	43.775	66308.0
2018-03-07 07:25:00	AAPL	Stock	43.775	43.81	43.755	43.81	8760.0
2018-03-07 07:30:00	AAPL	Stock	43.7975	43.8	43.7875	43.7875	9384.0
2018-03-07 07:35:00	AAPL	Stock	43.7875	43.7875	43.735	43.775	18712.0
2018-03-07 07:40:00	AAPL	Stock	43.775	43.84	43.775	43.775	22820.0
2018-03-07 07:45:00	AAPL	Stock	43.775	43.775	43.7525	43.7725	3600.0
2018-03-07 07:50:00	AAPL	Stock	43.7725	43.8375	43.7725	43.83	38316.0
2018-03-07 07:55:00	AAPL	Stock	43.83	43.8625	43.7925	43.8	51500.0
2018-03-07 08:00:00	AAPL	Stock	43.7925	43.83	43.7125	43.7675	118512.0
2018-03-07 08:05:00	AAPL	Stock	43.7625	43.775	43.7525	43.7525	24800.0
2018-03-07 08:10:00	AAPL	Stock	43.755	43.8	43.75	43.8	25232.0
2018-03-07 08:15:00	AAPL	Stock	43.775	43.825	43.775	43.825	19704.0
2018-03-07 08:20:00	AAPL	Stock	43.8125	43.87	43.8125	43.8625	52272.0
2018-03-07 08:25:00	AAPL	Stock	43.8625	43.8675	43.8475	43.8675	37656.0
2018-03-07 08:30:00	AAPL	Stock	43.855	43.87	43.8275	43.8275	32348.0
2018-03-07 08:35:00	AAPL	Stock	43.8375	43.845	43.8125	43.84	17980.0
2018-03-07 08:40:00	AAPL	Stock	43.855	43.855	43.8125	43.8125	13184.0
2018-03-07 08:45:00	AAPL	Stock	43.8	43.8125	43.7875	43.8125	32896.0
2018-03-07 08:50:00	AAPL	Stock	43.815	43.8625	43.815	43.8375	52968.0
2018-03-07 08:55:00	AAPL	Stock	43.825	43.8375	43.815	43.815	31840.0
2018-03-07 09:00:00	AAPL	Stock	43.825	43.83	43.7875	43.7875	19560.0
2018-03-07 09:05:00	AAPL	Stock	43.7775	43.8225	43.755	43.795	26148.0
2018-03-07 09:10:00	AAPL	Stock	43.8125	43.8375	43.7875	43.805	58448.0
2018-03-07 09:15:00	AAPL	Stock	43.805	43.8375	43.72	43.7475	159456.0
2018-03-07 09:20:00	AAPL	Stock	43.7475	43.75	43.7125	43.725	30496.0
2018-03-07 09:25:00	AAPL	Stock	43.72	43.7975	43.6925	43.7775	80908.0
2018-03-07 09:30:00	AAPL	Stock	43.7875	43.9138	43.725	43.8275	4897940.0
2018-03-07 09:35:00	AAPL	Stock	43.8175	43.88	43.765	43.8725	2837248.0

> showing 50 of 362,317 rows — these rows as CSV

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