PREVIEW / stock_30min / 2007-10-15

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-10-15.parquet
  size:    1.2 MB
  rows:    68,265
  symbols: 3,137

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
2007-10-15 05:30:00	AAPL	Stock	6.0314	6.0429	6.0314	6.0386	49700.0
2007-10-15 06:30:00	AAPL	Stock	6.0443	6.0446	6.0314	6.0339	70000.0
2007-10-15 07:00:00	AAPL	Stock	6.0339	6.0339	6.0168	6.0179	105644.0
2007-10-15 07:30:00	AAPL	Stock	6.0179	6.0193	5.9889	5.9896	182000.0
2007-10-15 08:00:00	AAPL	Stock	5.9896	6.0286	5.9896	6.0232	2340324.0
2007-10-15 08:30:00	AAPL	Stock	6.0246	6.025	5.9743	6.0143	3982020.0
2007-10-15 09:00:00	AAPL	Stock	6.0143	6.0157	5.9914	5.9936	3845688.0
2007-10-15 09:30:00	AAPL	Stock	5.9975	6.0561	5.9739	6.01	126149884.0
2007-10-15 10:00:00	AAPL	Stock	6.0089	6.0482	6.0018	6.0186	78033956.0
2007-10-15 10:30:00	AAPL	Stock	6.0179	6.0241	5.9743	5.9757	65781296.0
2007-10-15 11:00:00	AAPL	Stock	5.9755	5.9757	5.8393	5.9218	173118876.0
2007-10-15 11:30:00	AAPL	Stock	5.9214	5.9443	5.9082	5.9282	69377588.0
2007-10-15 12:00:00	AAPL	Stock	5.9286	5.9393	5.9125	5.9204	39387264.0
2007-10-15 12:30:00	AAPL	Stock	5.9204	5.9354	5.8925	5.9111	47671092.0
2007-10-15 13:00:00	AAPL	Stock	5.9125	5.9343	5.875	5.9336	67464376.0
2007-10-15 13:30:00	AAPL	Stock	5.9329	5.9657	5.91	5.9471	64014860.0
2007-10-15 14:00:00	AAPL	Stock	5.9468	5.9582	5.9046	5.95	57400532.0
2007-10-15 14:30:00	AAPL	Stock	5.9511	5.9575	5.9032	5.9221	52059644.0
2007-10-15 15:00:00	AAPL	Stock	5.9221	5.9486	5.8611	5.8818	103049604.0
2007-10-15 15:30:00	AAPL	Stock	5.8818	5.9639	5.8643	5.9639	107161012.0
2007-10-15 16:00:00	AAPL	Stock	5.9639	5.975	5.9375	5.9679	13187860.0
2007-10-15 16:30:00	AAPL	Stock	5.9711	5.9729	5.9226	5.9636	2429308.0
2007-10-15 17:00:00	AAPL	Stock	5.9636	5.9643	5.9	5.9607	609140.0
2007-10-15 17:30:00	AAPL	Stock	5.8861	5.96	5.8861	5.9571	635880.0
2007-10-15 18:00:00	AAPL	Stock	5.9571	5.9636	5.9536	5.9536	268576.0
2007-10-15 18:30:00	AAPL	Stock	5.9529	5.9607	5.9529	5.96	114828.0
2007-10-15 19:00:00	AAPL	Stock	5.9582	5.9607	5.9571	5.9571	112504.0
2007-10-15 19:30:00	AAPL	Stock	5.9554	5.9604	5.9525	5.9554	120400.0
2007-10-15 08:00:00	MSFT	Stock	30.15	30.17	30.15	30.15	1650.0
2007-10-15 08:30:00	MSFT	Stock	30.17	30.24	30.15	30.17	513834.0
2007-10-15 09:00:00	MSFT	Stock	30.17	30.23	30.08	30.08	26497.0
2007-10-15 09:30:00	MSFT	Stock	30.11	30.32	30.05	30.26	5080550.0
2007-10-15 10:00:00	MSFT	Stock	30.26	30.33	30.22	30.243	3785150.0
2007-10-15 10:30:00	MSFT	Stock	30.25	30.25	30.17	30.2	2864160.0
2007-10-15 11:00:00	MSFT	Stock	30.2	30.27	30.16	30.2	3316261.0
2007-10-15 11:30:00	MSFT	Stock	30.2	30.23	30.13	30.18	2805825.0
2007-10-15 12:00:00	MSFT	Stock	30.18	30.23	30.16	30.189	2628171.0
2007-10-15 12:30:00	MSFT	Stock	30.18	30.2	30.0	30.1	3609723.0
2007-10-15 13:00:00	MSFT	Stock	30.1	30.12	30.042	30.1	2841266.0
2007-10-15 13:30:00	MSFT	Stock	30.1	30.13	30.04	30.09	1340271.0
2007-10-15 14:00:00	MSFT	Stock	30.1	30.1	30.0	30.05	2503714.0
2007-10-15 14:30:00	MSFT	Stock	30.041	30.111	30.04	30.09	2535801.0
2007-10-15 15:00:00	MSFT	Stock	30.1	30.16	30.01	30.04	3311754.0
2007-10-15 15:30:00	MSFT	Stock	30.03	30.13	30.0	30.1	7248700.0
2007-10-15 16:00:00	MSFT	Stock	30.07	30.144	30.028	30.05	2383488.0
2007-10-15 16:30:00	MSFT	Stock	30.07	30.118	30.04	30.118	295233.0
2007-10-15 17:00:00	MSFT	Stock	30.171	30.171	30.03	30.05	42374.0
2007-10-15 18:00:00	MSFT	Stock	30.07	30.07	30.04	30.04	10392.0
2007-10-15 19:00:00	MSFT	Stock	30.08	30.1	30.08	30.1	5000.0
2007-10-15 19:30:00	MSFT	Stock	30.04	30.04	30.04	30.04	1125.0

> showing 50 of 68,265 rows — these rows as CSV

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