PREVIEW / stock_30min / 2009-11-05

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-11-05.parquet
  size:    1.4 MB
  rows:    74,827
  symbols: 3,399

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
2009-11-05 04:30:00	AAPL	Stock	6.8286	6.8286	6.8286	6.8286	2800.0
2009-11-05 06:00:00	AAPL	Stock	6.8286	6.8286	6.8286	6.8286	2800.0
2009-11-05 06:30:00	AAPL	Stock	6.8286	6.8286	6.8286	6.8286	4396.0
2009-11-05 07:30:00	AAPL	Stock	6.8339	6.8339	6.8229	6.8229	14000.0
2009-11-05 08:00:00	AAPL	Stock	6.8339	6.8643	6.8339	6.85	546168.0
2009-11-05 08:30:00	AAPL	Stock	6.8464	6.875	6.8464	6.8596	1057420.0
2009-11-05 09:00:00	AAPL	Stock	6.8596	6.8839	6.8146	6.87	1771196.0
2009-11-05 09:30:00	AAPL	Stock	6.8704	6.9071	6.8507	6.9036	62711656.0
2009-11-05 10:00:00	AAPL	Stock	6.9039	6.95	6.8943	6.94	49149828.0
2009-11-05 10:30:00	AAPL	Stock	6.9404	6.9643	6.9357	6.9457	38105872.0
2009-11-05 11:00:00	AAPL	Stock	6.9464	6.9536	6.9221	6.9236	22360800.0
2009-11-05 11:30:00	AAPL	Stock	6.9254	6.9379	6.9107	6.9143	20980176.0
2009-11-05 12:00:00	AAPL	Stock	6.9139	6.945	6.91	6.9291	12109916.0
2009-11-05 12:30:00	AAPL	Stock	6.9286	6.9304	6.9182	6.9207	12059712.0
2009-11-05 13:00:00	AAPL	Stock	6.9211	6.9289	6.9107	6.9154	11698176.0
2009-11-05 13:30:00	AAPL	Stock	6.9157	6.9321	6.9134	6.9214	17438204.0
2009-11-05 14:00:00	AAPL	Stock	6.9211	6.9414	6.9211	6.9354	19508244.0
2009-11-05 14:30:00	AAPL	Stock	6.935	6.9425	6.9254	6.9311	17201352.0
2009-11-05 15:00:00	AAPL	Stock	6.9307	6.9379	6.9121	6.9175	22773968.0
2009-11-05 15:30:00	AAPL	Stock	6.9172	6.9343	6.9018	6.9343	46035024.0
2009-11-05 16:00:00	AAPL	Stock	6.9346	6.9364	6.9117	6.9364	9924152.0
2009-11-05 16:30:00	AAPL	Stock	6.9296	6.935	6.9293	6.9304	937776.0
2009-11-05 17:00:00	AAPL	Stock	6.9304	6.9318	6.9286	6.9314	164640.0
2009-11-05 17:30:00	AAPL	Stock	6.9321	6.9321	6.9286	6.9289	94360.0
2009-11-05 18:00:00	AAPL	Stock	6.9296	6.9339	6.9296	6.9321	2875936.0
2009-11-05 18:30:00	AAPL	Stock	6.9307	6.9307	6.9307	6.9307	3640.0
2009-11-05 19:00:00	AAPL	Stock	6.9329	6.9329	6.9304	6.9307	24276.0
2009-11-05 19:30:00	AAPL	Stock	6.9311	6.9311	6.9286	6.9286	51436.0
2009-11-05 05:30:00	MSFT	Stock	28.29	28.29	28.29	28.29	300.0
2009-11-05 07:30:00	MSFT	Stock	28.31	28.41	28.3	28.35	3941.0
2009-11-05 08:00:00	MSFT	Stock	28.35	28.37	28.32	28.32	3029.0
2009-11-05 08:30:00	MSFT	Stock	28.37	28.44	28.06	28.41	24931.0
2009-11-05 09:00:00	MSFT	Stock	28.45	28.53	28.06	28.5	54224.0
2009-11-05 09:30:00	MSFT	Stock	28.52	28.6	28.28	28.51	5613055.0
2009-11-05 10:00:00	MSFT	Stock	28.502	28.655	28.463	28.62	4929035.0
2009-11-05 10:30:00	MSFT	Stock	28.625	28.74	28.61	28.675	4897212.0
2009-11-05 11:00:00	MSFT	Stock	28.685	28.71	28.62	28.68	2842634.0
2009-11-05 11:30:00	MSFT	Stock	28.67	28.72	28.6	28.64	2383511.0
2009-11-05 12:00:00	MSFT	Stock	28.631	28.71	28.62	28.66	2380981.0
2009-11-05 12:30:00	MSFT	Stock	28.67	28.72	28.58	28.63	3484065.0
2009-11-05 13:00:00	MSFT	Stock	28.63	28.65	28.52	28.54	2051638.0
2009-11-05 13:30:00	MSFT	Stock	28.53	28.64	28.518	28.555	2407563.0
2009-11-05 14:00:00	MSFT	Stock	28.555	28.6	28.53	28.57	1917061.0
2009-11-05 14:30:00	MSFT	Stock	28.568	28.62	28.56	28.6	3134060.0
2009-11-05 15:00:00	MSFT	Stock	28.6	28.6	28.46	28.485	2872201.0
2009-11-05 15:30:00	MSFT	Stock	28.482	28.5	28.4	28.47	5718801.0
2009-11-05 16:00:00	MSFT	Stock	28.48	28.609	28.4	28.47	3833898.0
2009-11-05 16:30:00	MSFT	Stock	28.45	28.51	28.44	28.51	167684.0
2009-11-05 17:00:00	MSFT	Stock	28.666	28.666	28.46	28.51	3705.0
2009-11-05 17:30:00	MSFT	Stock	28.52	28.54	28.49	28.53	19000.0

> showing 50 of 74,827 rows — these rows as CSV

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