PREVIEW / stock_30min / 2018-06-21

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-06-21.parquet
  size:    1.7 MB
  rows:    83,411
  symbols: 2,824

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-06-21 04:30:00	AAPL	Stock	46.8325	46.8325	46.8325	46.8325	400.0
2018-06-21 05:00:00	AAPL	Stock	46.75	46.75	46.6025	46.6025	9920.0
2018-06-21 05:30:00	AAPL	Stock	46.6625	46.6625	46.6625	46.6625	400.0
2018-06-21 06:00:00	AAPL	Stock	46.6575	46.7	46.6575	46.6975	5644.0
2018-06-21 06:30:00	AAPL	Stock	46.7125	46.76	46.705	46.76	5464.0
2018-06-21 07:00:00	AAPL	Stock	46.8875	46.8875	46.755	46.8225	27956.0
2018-06-21 07:30:00	AAPL	Stock	46.8225	46.965	46.8225	46.9625	95056.0
2018-06-21 08:00:00	AAPL	Stock	46.8495	46.98	46.8175	46.91	202620.0
2018-06-21 08:30:00	AAPL	Stock	46.905	46.905	46.785	46.845	115332.0
2018-06-21 09:00:00	AAPL	Stock	46.8325	46.88	46.8	46.8	87560.0
2018-06-21 09:30:00	AAPL	Stock	46.8025	47.0875	46.74	46.9475	9418592.0
2018-06-21 10:00:00	AAPL	Stock	46.9438	46.945	46.675	46.7675	8180000.0
2018-06-21 10:30:00	AAPL	Stock	46.77	46.8225	46.615	46.665	5433216.0
2018-06-21 11:00:00	AAPL	Stock	46.6625	46.7325	46.5825	46.6662	4229364.0
2018-06-21 11:30:00	AAPL	Stock	46.6675	46.81	46.665	46.6675	3331040.0
2018-06-21 12:00:00	AAPL	Stock	46.665	46.67	46.3675	46.39	5861740.0
2018-06-21 12:30:00	AAPL	Stock	46.385	46.415	46.2725	46.3225	5405324.0
2018-06-21 13:00:00	AAPL	Stock	46.3225	46.405	46.2952	46.3525	3519028.0
2018-06-21 13:30:00	AAPL	Stock	46.3525	46.4012	46.2825	46.3212	2800568.0
2018-06-21 14:00:00	AAPL	Stock	46.32	46.4	46.2875	46.3325	2915540.0
2018-06-21 14:30:00	AAPL	Stock	46.335	46.38	46.2675	46.2675	3408340.0
2018-06-21 15:00:00	AAPL	Stock	46.2675	46.3925	46.235	46.37	5320560.0
2018-06-21 15:30:00	AAPL	Stock	46.365	46.375	46.24	46.3675	7169084.0
2018-06-21 16:00:00	AAPL	Stock	46.365	46.365	46.265	46.285	8900168.0
2018-06-21 16:30:00	AAPL	Stock	46.3	46.365	46.255	46.255	60016.0
2018-06-21 17:00:00	AAPL	Stock	46.2855	46.3092	46.2375	46.2375	39520.0
2018-06-21 17:30:00	AAPL	Stock	46.2475	46.2875	46.2475	46.2775	24800.0
2018-06-21 18:00:00	AAPL	Stock	46.2875	46.3125	46.255	46.305	37816.0
2018-06-21 18:30:00	AAPL	Stock	46.295	46.3	46.255	46.255	7460.0
2018-06-21 19:00:00	AAPL	Stock	46.2875	46.2875	46.25	46.2825	2936.0
2018-06-21 19:30:00	AAPL	Stock	46.25	46.275	46.25	46.27	16500.0
2018-06-21 04:30:00	MSFT	Stock	102.05	102.05	102.05	102.05	100.0
2018-06-21 06:30:00	MSFT	Stock	101.87	101.88	101.87	101.88	379.0
2018-06-21 07:00:00	MSFT	Stock	101.93	102.07	101.87	102.0	3063.0
2018-06-21 07:30:00	MSFT	Stock	102.0	102.01	101.88	101.88	1966.0
2018-06-21 08:00:00	MSFT	Stock	102.01	102.08	101.87	101.88	13633.0
2018-06-21 08:30:00	MSFT	Stock	101.71	101.87	101.51	101.87	12634.0
2018-06-21 09:00:00	MSFT	Stock	101.78	102.33	101.75	102.12	23114.0
2018-06-21 09:30:00	MSFT	Stock	102.08	102.46	101.63	102.17	2525424.0
2018-06-21 10:00:00	MSFT	Stock	102.17	102.17	101.11	101.38	1967393.0
2018-06-21 10:30:00	MSFT	Stock	101.38	101.75	100.98	101.64	1657633.0
2018-06-21 11:00:00	MSFT	Stock	101.64	101.73	101.35	101.53	1111508.0
2018-06-21 11:30:00	MSFT	Stock	101.54	101.8	101.53	101.75	952878.0
2018-06-21 12:00:00	MSFT	Stock	101.75	101.76	101.451	101.47	983462.0
2018-06-21 12:30:00	MSFT	Stock	101.464	101.51	101.14	101.17	890735.0
2018-06-21 13:00:00	MSFT	Stock	101.17	101.555	101.11	101.4	664586.0
2018-06-21 13:30:00	MSFT	Stock	101.41	101.46	101.19	101.295	644548.0
2018-06-21 14:00:00	MSFT	Stock	101.29	101.435	101.25	101.28	661351.0
2018-06-21 14:30:00	MSFT	Stock	101.28	101.44	101.16	101.17	603337.0
2018-06-21 15:00:00	MSFT	Stock	101.16	101.38	101.01	101.25	1329674.0

> showing 50 of 83,411 rows — these rows as CSV

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