PREVIEW / stock_30min / 2009-09-23

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-09-23.parquet
  size:    1.4 MB
  rows:    75,240
  symbols: 3,393

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-09-23 07:00:00	AAPL	Stock	6.6071	6.6071	6.6071	6.6071	5600.0
2009-09-23 07:30:00	AAPL	Stock	6.6071	6.6236	6.6071	6.6236	45780.0
2009-09-23 08:00:00	AAPL	Stock	6.6179	6.6236	6.5721	6.6071	1126832.0
2009-09-23 08:30:00	AAPL	Stock	6.6104	6.6229	6.6071	6.6196	567952.0
2009-09-23 09:00:00	AAPL	Stock	6.6175	6.625	6.6139	6.6211	623924.0
2009-09-23 09:30:00	AAPL	Stock	6.6214	6.7093	6.6082	6.6889	101089240.0
2009-09-23 10:00:00	AAPL	Stock	6.6904	6.7054	6.6696	6.6707	54027764.0
2009-09-23 10:30:00	AAPL	Stock	6.6711	6.6846	6.6429	6.6732	42936712.0
2009-09-23 11:00:00	AAPL	Stock	6.6739	6.6839	6.6618	6.6789	18348932.0
2009-09-23 11:30:00	AAPL	Stock	6.6787	6.7032	6.6757	6.7	21669144.0
2009-09-23 12:00:00	AAPL	Stock	6.6996	6.7189	6.6979	6.7089	29689184.0
2009-09-23 12:30:00	AAPL	Stock	6.7083	6.7143	6.6904	6.7075	20641796.0
2009-09-23 13:00:00	AAPL	Stock	6.7086	6.7214	6.7014	6.7057	23556820.0
2009-09-23 13:30:00	AAPL	Stock	6.7061	6.7229	6.7036	6.7089	25607148.0
2009-09-23 14:00:00	AAPL	Stock	6.7086	6.73	6.7082	6.7289	38055108.0
2009-09-23 14:30:00	AAPL	Stock	6.7296	6.7464	6.7057	6.7093	63866628.0
2009-09-23 15:00:00	AAPL	Stock	6.7107	6.7307	6.6724	6.685	56628264.0
2009-09-23 15:30:00	AAPL	Stock	6.6854	6.6911	6.6121	6.6261	84572348.0
2009-09-23 16:00:00	AAPL	Stock	6.6264	6.6885	6.6246	6.6321	4769884.0
2009-09-23 16:30:00	AAPL	Stock	6.625	6.6882	6.625	6.6386	411712.0
2009-09-23 17:00:00	AAPL	Stock	6.6382	6.6486	6.6357	6.6439	290612.0
2009-09-23 17:30:00	AAPL	Stock	6.6475	6.6571	6.6468	6.6571	753592.0
2009-09-23 18:00:00	AAPL	Stock	6.6571	6.6714	6.625	6.6618	589484.0
2009-09-23 18:30:00	AAPL	Stock	6.6661	6.6671	6.6625	6.6671	166320.0
2009-09-23 19:00:00	AAPL	Stock	6.6675	6.6714	6.6614	6.6625	494620.0
2009-09-23 19:30:00	AAPL	Stock	6.6643	6.6661	6.6575	6.6661	280028.0
2009-09-23 08:00:00	MSFT	Stock	25.84	25.87	25.3	25.87	25400.0
2009-09-23 08:30:00	MSFT	Stock	25.87	25.89	25.86	25.89	7300.0
2009-09-23 09:00:00	MSFT	Stock	25.86	25.95	25.86	25.95	46181.0
2009-09-23 09:30:00	MSFT	Stock	25.92	26.0	25.8	25.91	7224241.0
2009-09-23 10:00:00	MSFT	Stock	25.92	26.0	25.895	25.96	4505913.0
2009-09-23 10:30:00	MSFT	Stock	25.95	25.99	25.86	25.92	4346944.0
2009-09-23 11:00:00	MSFT	Stock	25.93	25.97	25.91	25.94	2482222.0
2009-09-23 11:30:00	MSFT	Stock	25.95	25.99	25.94	25.972	3018821.0
2009-09-23 12:00:00	MSFT	Stock	25.98	26.02	25.96	26.0	4184022.0
2009-09-23 12:30:00	MSFT	Stock	26.0	26.02	25.96	26.01	1344918.0
2009-09-23 13:00:00	MSFT	Stock	26.002	26.01	25.95	25.96	1738345.0
2009-09-23 13:30:00	MSFT	Stock	25.96	26.09	25.95	26.085	2815469.0
2009-09-23 14:00:00	MSFT	Stock	26.08	26.21	26.04	26.19	4346462.0
2009-09-23 14:30:00	MSFT	Stock	26.19	26.25	26.04	26.06	5342432.0
2009-09-23 15:00:00	MSFT	Stock	26.06	26.12	25.9	25.94	6150242.0
2009-09-23 15:30:00	MSFT	Stock	25.94	25.94	25.64	25.71	10674241.0
2009-09-23 16:00:00	MSFT	Stock	25.72	25.972	25.68	25.74	1627816.0
2009-09-23 16:30:00	MSFT	Stock	25.72	25.75	25.72	25.75	35703.0
2009-09-23 17:00:00	MSFT	Stock	25.74	25.74	25.72	25.72	3315.0
2009-09-23 17:30:00	MSFT	Stock	25.73	25.73	25.73	25.73	2282.0
2009-09-23 18:00:00	MSFT	Stock	25.71	25.77	25.71	25.77	15341.0
2009-09-23 18:30:00	MSFT	Stock	25.75	25.75	25.75	25.75	1300.0
2009-09-23 19:00:00	MSFT	Stock	25.75	25.75	25.73	25.73	523.0
2009-09-23 19:30:00	MSFT	Stock	25.73	25.73	25.73	25.73	575.0

> showing 50 of 75,240 rows — these rows as CSV

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