PREVIEW / stock_30min / 2007-12-04

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-12-04.parquet
  size:    1.2 MB
  rows:    69,704
  symbols: 3,218

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-12-04 05:00:00	AAPL	Stock	6.375	6.375	6.3729	6.3729	14000.0
2007-12-04 05:30:00	AAPL	Stock	6.3721	6.3721	6.3721	6.3721	2800.0
2007-12-04 06:30:00	AAPL	Stock	6.3571	6.3571	6.3571	6.3571	53200.0
2007-12-04 07:00:00	AAPL	Stock	6.3571	6.375	6.3371	6.3429	99176.0
2007-12-04 07:30:00	AAPL	Stock	6.3429	6.35	6.3325	6.345	251328.0
2007-12-04 08:00:00	AAPL	Stock	6.345	6.35	6.2925	6.3	3568544.0
2007-12-04 08:30:00	AAPL	Stock	6.3014	6.3318	6.3	6.3157	2813888.0
2007-12-04 09:00:00	AAPL	Stock	6.3157	6.335	6.3079	6.3268	2985164.0
2007-12-04 09:30:00	AAPL	Stock	6.3257	6.4418	6.3211	6.42	149090312.0
2007-12-04 10:00:00	AAPL	Stock	6.4189	6.4357	6.3936	6.4205	67879280.0
2007-12-04 10:30:00	AAPL	Stock	6.4218	6.4518	6.4021	6.4046	70117208.0
2007-12-04 11:00:00	AAPL	Stock	6.4046	6.4607	6.3968	6.4364	61501020.0
2007-12-04 11:30:00	AAPL	Stock	6.4364	6.4482	6.4061	6.4161	43731492.0
2007-12-04 12:00:00	AAPL	Stock	6.4164	6.4386	6.4068	6.4243	37351048.0
2007-12-04 12:30:00	AAPL	Stock	6.4246	6.4429	6.4143	6.4296	27583892.0
2007-12-04 13:00:00	AAPL	Stock	6.4293	6.4504	6.4089	6.4111	30432164.0
2007-12-04 13:30:00	AAPL	Stock	6.411	6.4321	6.3996	6.4171	31673768.0
2007-12-04 14:00:00	AAPL	Stock	6.4171	6.4171	6.3304	6.37	60361168.0
2007-12-04 14:30:00	AAPL	Stock	6.3704	6.4082	6.3629	6.4021	43852256.0
2007-12-04 15:00:00	AAPL	Stock	6.4018	6.4286	6.3864	6.4118	54118484.0
2007-12-04 15:30:00	AAPL	Stock	6.4114	6.4264	6.3911	6.4225	69975500.0
2007-12-04 16:00:00	AAPL	Stock	6.4218	6.4275	6.3611	6.4214	11730180.0
2007-12-04 16:30:00	AAPL	Stock	6.4218	6.4236	6.4154	6.4214	1992228.0
2007-12-04 17:00:00	AAPL	Stock	6.4196	6.4282	6.4196	6.4218	2531032.0
2007-12-04 17:30:00	AAPL	Stock	6.4225	6.4229	6.4218	6.4229	95816.0
2007-12-04 18:00:00	AAPL	Stock	6.4229	6.4261	6.4229	6.425	62720.0
2007-12-04 18:30:00	AAPL	Stock	6.4232	6.4264	6.4229	6.4264	74900.0
2007-12-04 19:00:00	AAPL	Stock	6.4264	6.4264	6.4214	6.4214	63560.0
2007-12-04 19:30:00	AAPL	Stock	6.4225	6.4286	6.4225	6.4286	140616.0
2007-12-04 07:00:00	MSFT	Stock	32.95	32.95	32.9	32.9	300.0
2007-12-04 07:30:00	MSFT	Stock	32.8	32.8	32.75	32.75	500.0
2007-12-04 08:00:00	MSFT	Stock	32.86	32.86	32.74	32.75	1069.0
2007-12-04 08:30:00	MSFT	Stock	32.75	32.8	32.75	32.8	2500.0
2007-12-04 09:00:00	MSFT	Stock	32.8	32.93	32.74	32.75	4024081.0
2007-12-04 09:30:00	MSFT	Stock	32.75	33.24	32.74	33.22	7864354.0
2007-12-04 10:00:00	MSFT	Stock	33.22	33.24	32.76	33.11	3989329.0
2007-12-04 10:30:00	MSFT	Stock	33.119	33.24	33.11	33.13	2631458.0
2007-12-04 11:00:00	MSFT	Stock	33.14	33.17	33.02	33.03	2342662.0
2007-12-04 11:30:00	MSFT	Stock	33.03	33.14	32.95	33.02	2958214.0
2007-12-04 12:00:00	MSFT	Stock	33.02	33.05	32.96	33.008	3172195.0
2007-12-04 12:30:00	MSFT	Stock	33.0	33.02	32.88	32.975	1616910.0
2007-12-04 13:00:00	MSFT	Stock	32.97	33.05	32.93	32.948	2662755.0
2007-12-04 13:30:00	MSFT	Stock	32.94	32.96	32.83	32.84	2773173.0
2007-12-04 14:00:00	MSFT	Stock	32.84	32.84	32.63	32.725	4434897.0
2007-12-04 14:30:00	MSFT	Stock	32.72	32.95	32.63	32.88	3972761.0
2007-12-04 15:00:00	MSFT	Stock	32.88	32.94	32.75	32.77	3373841.0
2007-12-04 15:30:00	MSFT	Stock	32.77	32.8	32.7	32.79	5416227.0
2007-12-04 16:00:00	MSFT	Stock	32.79	32.93	32.61	32.7	2164059.0
2007-12-04 16:30:00	MSFT	Stock	32.72	32.942	32.7	32.77	1108833.0
2007-12-04 17:00:00	MSFT	Stock	32.71	33.0	32.7	32.77	405095.0

> showing 50 of 69,704 rows — these rows as CSV

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