PREVIEW / stock_30min / 2018-06-14

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-06-14.parquet
  size:    1.7 MB
  rows:    83,662
  symbols: 2,828

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-14 04:00:00	AAPL	Stock	47.6575	47.6575	47.6575	47.6575	2800.0
2018-06-14 05:00:00	AAPL	Stock	47.66	47.6625	47.65	47.6625	10524.0
2018-06-14 05:30:00	AAPL	Stock	47.725	47.725	47.6225	47.6225	2400.0
2018-06-14 06:00:00	AAPL	Stock	47.5875	47.6275	47.585	47.6275	8400.0
2018-06-14 06:30:00	AAPL	Stock	47.625	47.625	47.625	47.625	1400.0
2018-06-14 07:00:00	AAPL	Stock	47.625	47.6825	47.61	47.6825	41852.0
2018-06-14 07:30:00	AAPL	Stock	47.705	47.785	47.6975	47.785	25820.0
2018-06-14 08:00:00	AAPL	Stock	47.6775	47.835	47.62	47.825	141988.0
2018-06-14 08:30:00	AAPL	Stock	47.825	47.855	47.7875	47.7925	196212.0
2018-06-14 09:00:00	AAPL	Stock	47.8	47.8875	47.7925	47.8875	88872.0
2018-06-14 09:30:00	AAPL	Stock	47.8875	47.8925	47.555	47.6575	12166140.0
2018-06-14 10:00:00	AAPL	Stock	47.655	47.8825	47.655	47.8325	6580552.0
2018-06-14 10:30:00	AAPL	Stock	47.8325	47.84	47.6325	47.6347	4919592.0
2018-06-14 11:00:00	AAPL	Stock	47.6325	47.81	47.5902	47.7675	4382152.0
2018-06-14 11:30:00	AAPL	Stock	47.7675	47.86	47.765	47.7775	3048792.0
2018-06-14 12:00:00	AAPL	Stock	47.7758	47.8125	47.7025	47.7075	2804848.0
2018-06-14 12:30:00	AAPL	Stock	47.705	47.725	47.655	47.6912	4139964.0
2018-06-14 13:00:00	AAPL	Stock	47.6925	47.7875	47.6725	47.7562	2707036.0
2018-06-14 13:30:00	AAPL	Stock	47.7575	47.835	47.7375	47.7375	3148096.0
2018-06-14 14:00:00	AAPL	Stock	47.74	47.7825	47.725	47.7438	2410404.0
2018-06-14 14:30:00	AAPL	Stock	47.7425	47.7625	47.64	47.65	2449108.0
2018-06-14 15:00:00	AAPL	Stock	47.6525	47.7325	47.6475	47.7265	3529584.0
2018-06-14 15:30:00	AAPL	Stock	47.725	47.7925	47.625	47.7025	10859128.0
2018-06-14 16:00:00	AAPL	Stock	47.7	47.7375	47.6975	47.7125	9952740.0
2018-06-14 16:30:00	AAPL	Stock	47.7	47.7125	47.7	47.7025	24972.0
2018-06-14 17:00:00	AAPL	Stock	47.705	47.72	47.7	47.7175	10520.0
2018-06-14 17:30:00	AAPL	Stock	47.71	47.73	47.68	47.7	34148.0
2018-06-14 18:00:00	AAPL	Stock	47.675	47.7025	47.625	47.7025	11936.0
2018-06-14 18:30:00	AAPL	Stock	47.69	47.69	47.69	47.69	1600.0
2018-06-14 19:00:00	AAPL	Stock	47.7	47.7	47.675	47.675	7280.0
2018-06-14 19:30:00	AAPL	Stock	47.675	47.675	47.6275	47.65	32196.0
2018-06-14 04:00:00	MSFT	Stock	100.78	100.85	100.78	100.85	400.0
2018-06-14 05:30:00	MSFT	Stock	100.85	100.85	100.85	100.85	121.0
2018-06-14 07:00:00	MSFT	Stock	100.9	100.9	100.9	100.9	100.0
2018-06-14 07:30:00	MSFT	Stock	100.9	101.0	100.9	101.0	8483.0
2018-06-14 08:00:00	MSFT	Stock	100.95	101.11	100.75	101.02	3782.0
2018-06-14 08:30:00	MSFT	Stock	101.1	101.17	101.05	101.15	15499.0
2018-06-14 09:00:00	MSFT	Stock	101.15	101.65	101.13	101.65	38892.0
2018-06-14 09:30:00	MSFT	Stock	101.65	101.69	101.0	101.11	3427299.0
2018-06-14 10:00:00	MSFT	Stock	101.1	102.03	101.095	101.87	2422415.0
2018-06-14 10:30:00	MSFT	Stock	101.87	101.915	101.4	101.43	1624992.0
2018-06-14 11:00:00	MSFT	Stock	101.434	101.71	101.235	101.58	1117286.0
2018-06-14 11:30:00	MSFT	Stock	101.585	101.89	101.585	101.68	917424.0
2018-06-14 12:00:00	MSFT	Stock	101.685	101.75	101.52	101.54	715692.0
2018-06-14 12:30:00	MSFT	Stock	101.53	101.545	101.3	101.32	645082.0
2018-06-14 13:00:00	MSFT	Stock	101.315	101.65	101.28	101.595	721664.0
2018-06-14 13:30:00	MSFT	Stock	101.6	101.76	101.51	101.514	741386.0
2018-06-14 14:00:00	MSFT	Stock	101.51	101.57	101.36	101.397	733394.0
2018-06-14 14:30:00	MSFT	Stock	101.395	101.415	101.13	101.15	757139.0
2018-06-14 15:00:00	MSFT	Stock	101.15	101.38	101.14	101.345	1039016.0

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

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