PREVIEW / stock_30min / 2008-06-20

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-06-20.parquet
  size:    1.3 MB
  rows:    72,007
  symbols: 3,325

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
2008-06-20 06:00:00	AAPL	Stock	6.4839	6.4839	6.4779	6.4779	19040.0
2008-06-20 06:30:00	AAPL	Stock	6.4814	6.4814	6.4643	6.4643	28280.0
2008-06-20 07:00:00	AAPL	Stock	6.4536	6.4536	6.4304	6.4304	119000.0
2008-06-20 07:30:00	AAPL	Stock	6.4286	6.4318	6.3929	6.4286	478324.0
2008-06-20 08:00:00	AAPL	Stock	6.4232	6.4257	6.4039	6.4196	916664.0
2008-06-20 08:30:00	AAPL	Stock	6.4196	6.4221	6.4104	6.4168	911260.0
2008-06-20 09:00:00	AAPL	Stock	6.4164	6.4182	6.3929	6.4004	1481984.0
2008-06-20 09:30:00	AAPL	Stock	6.4004	6.4643	6.3571	6.3679	167100612.0
2008-06-20 10:00:00	AAPL	Stock	6.3686	6.3786	6.3346	6.3779	71117704.0
2008-06-20 10:30:00	AAPL	Stock	6.3782	6.3786	6.3143	6.3479	67993520.0
2008-06-20 11:00:00	AAPL	Stock	6.3471	6.3554	6.3179	6.3439	47962600.0
2008-06-20 11:30:00	AAPL	Stock	6.345	6.3732	6.3361	6.3732	40196856.0
2008-06-20 12:00:00	AAPL	Stock	6.3732	6.3761	6.335	6.3475	34442380.0
2008-06-20 12:30:00	AAPL	Stock	6.3461	6.3479	6.3204	6.3293	27650140.0
2008-06-20 13:00:00	AAPL	Stock	6.3293	6.3511	6.2964	6.2972	41553624.0
2008-06-20 13:30:00	AAPL	Stock	6.2989	6.3157	6.2825	6.3068	42936264.0
2008-06-20 14:00:00	AAPL	Stock	6.3068	6.3146	6.2821	6.31	43604876.0
2008-06-20 14:30:00	AAPL	Stock	6.3093	6.3189	6.2625	6.2696	51102828.0
2008-06-20 15:00:00	AAPL	Stock	6.2696	6.2936	6.25	6.2793	73513188.0
2008-06-20 15:30:00	AAPL	Stock	6.2793	6.2832	6.2504	6.2564	95348064.0
2008-06-20 16:00:00	AAPL	Stock	6.2564	6.33	6.25	6.25	35053284.0
2008-06-20 16:30:00	AAPL	Stock	6.2596	6.4636	6.2482	6.2511	4680004.0
2008-06-20 17:00:00	AAPL	Stock	6.25	6.272	6.2493	6.2504	6737276.0
2008-06-20 17:30:00	AAPL	Stock	6.2504	6.2646	6.2504	6.2554	146944.0
2008-06-20 18:00:00	AAPL	Stock	6.255	6.2554	6.2543	6.2554	82040.0
2008-06-20 18:30:00	AAPL	Stock	6.2554	6.2554	6.25	6.2518	81676.0
2008-06-20 19:00:00	AAPL	Stock	6.2543	6.2543	6.2429	6.25	278432.0
2008-06-20 19:30:00	AAPL	Stock	6.25	6.255	6.25	6.2504	89880.0
2008-06-20 08:00:00	MSFT	Stock	28.85	28.85	28.73	28.77	9700.0
2008-06-20 08:30:00	MSFT	Stock	28.77	28.78	28.7	28.7	3074.0
2008-06-20 09:00:00	MSFT	Stock	28.67	29.25	28.67	28.91	963023.0
2008-06-20 09:30:00	MSFT	Stock	28.9	28.92	28.65	28.735	20880303.0
2008-06-20 10:00:00	MSFT	Stock	28.73	28.78	28.63	28.7	5740269.0
2008-06-20 10:30:00	MSFT	Stock	28.7	28.7	28.5	28.54	4915818.0
2008-06-20 11:00:00	MSFT	Stock	28.55	28.6	28.38	28.5	4703970.0
2008-06-20 11:30:00	MSFT	Stock	28.51	28.51	28.44	28.46	2748119.0
2008-06-20 12:00:00	MSFT	Stock	28.46	28.46	28.31	28.378	2283952.0
2008-06-20 12:30:00	MSFT	Stock	28.37	28.48	28.33	28.38	2971829.0
2008-06-20 13:00:00	MSFT	Stock	28.38	28.49	28.25	28.26	3857084.0
2008-06-20 13:30:00	MSFT	Stock	28.25	28.32	28.2	28.27	3947994.0
2008-06-20 14:00:00	MSFT	Stock	28.27	28.35	28.14	28.25	4318707.0
2008-06-20 14:30:00	MSFT	Stock	28.252	28.35	28.11	28.13	3424693.0
2008-06-20 15:00:00	MSFT	Stock	28.13	28.26	28.1	28.19	4820196.0
2008-06-20 15:30:00	MSFT	Stock	28.19	28.35	28.16	28.25	8276258.0
2008-06-20 16:00:00	MSFT	Stock	28.239	28.508	28.19	28.23	6805822.0
2008-06-20 16:30:00	MSFT	Stock	28.24	28.393	28.22	28.25	656325.0
2008-06-20 17:00:00	MSFT	Stock	28.23	28.24	28.23	28.23	796109.0
2008-06-20 17:30:00	MSFT	Stock	28.24	28.252	28.207	28.25	7239.0
2008-06-20 18:00:00	MSFT	Stock	28.25	28.25	28.24	28.24	1100.0
2008-06-20 18:30:00	MSFT	Stock	28.23	28.24	28.23	28.23	1700.0

> showing 50 of 72,007 rows — these rows as CSV

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