PREVIEW / stock_30min / 2009-01-09

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-01-09.parquet
  size:    1.2 MB
  rows:    69,317
  symbols: 3,307

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-01-09 08:00:00	AAPL	Stock	3.2982	3.3268	3.2982	3.3132	293972.0
2009-01-09 08:30:00	AAPL	Stock	3.3196	3.3536	3.3196	3.3343	1830276.0
2009-01-09 09:00:00	AAPL	Stock	3.3343	3.3354	3.3286	3.3321	638204.0
2009-01-09 09:30:00	AAPL	Stock	3.3321	3.335	3.2464	3.2479	84611268.0
2009-01-09 10:00:00	AAPL	Stock	3.2482	3.2632	3.2282	3.2346	56517916.0
2009-01-09 10:30:00	AAPL	Stock	3.2346	3.2496	3.2193	3.2339	43081360.0
2009-01-09 11:00:00	AAPL	Stock	3.2336	3.2532	3.2293	3.2404	34951784.0
2009-01-09 11:30:00	AAPL	Stock	3.2404	3.2464	3.2232	3.2336	27578544.0
2009-01-09 12:00:00	AAPL	Stock	3.2335	3.2482	3.2293	3.2396	22160796.0
2009-01-09 12:30:00	AAPL	Stock	3.2396	3.25	3.2357	3.245	19532380.0
2009-01-09 13:00:00	AAPL	Stock	3.245	3.2579	3.2321	3.2418	31835748.0
2009-01-09 13:30:00	AAPL	Stock	3.2418	3.2636	3.2343	3.2493	29562456.0
2009-01-09 14:00:00	AAPL	Stock	3.2493	3.2689	3.2493	3.2611	27837236.0
2009-01-09 14:30:00	AAPL	Stock	3.2611	3.2768	3.2579	3.2657	39417196.0
2009-01-09 15:00:00	AAPL	Stock	3.2657	3.2725	3.2339	3.2418	43480808.0
2009-01-09 15:30:00	AAPL	Stock	3.2411	3.2571	3.2239	3.235	65647708.0
2009-01-09 16:00:00	AAPL	Stock	3.2343	3.2517	3.2268	3.2314	11828600.0
2009-01-09 16:30:00	AAPL	Stock	3.235	3.235	3.23	3.2307	2374792.0
2009-01-09 17:00:00	AAPL	Stock	3.2304	3.235	3.2293	3.2304	345828.0
2009-01-09 17:30:00	AAPL	Stock	3.2293	3.235	3.2286	3.2346	247884.0
2009-01-09 18:00:00	AAPL	Stock	3.2357	3.2411	3.2321	3.2411	2841776.0
2009-01-09 18:30:00	AAPL	Stock	3.24	3.24	3.24	3.24	5600.0
2009-01-09 19:00:00	AAPL	Stock	3.2386	3.2386	3.2371	3.2375	22624.0
2009-01-09 19:30:00	AAPL	Stock	3.24	3.2407	3.2329	3.2364	96880.0
2009-01-09 06:00:00	MSFT	Stock	20.05	20.05	20.05	20.05	200.0
2009-01-09 06:30:00	MSFT	Stock	20.05	20.05	20.05	20.05	180.0
2009-01-09 07:30:00	MSFT	Stock	20.25	20.25	20.25	20.25	1980.0
2009-01-09 08:00:00	MSFT	Stock	20.05	20.05	19.97	19.97	3690.0
2009-01-09 08:30:00	MSFT	Stock	19.97	20.12	19.97	20.1	13025.0
2009-01-09 09:00:00	MSFT	Stock	20.1	20.18	20.05	20.18	65270.0
2009-01-09 09:30:00	MSFT	Stock	20.17	20.3	19.73	19.74	5955082.0
2009-01-09 10:00:00	MSFT	Stock	19.74	19.91	19.67	19.8	4272654.0
2009-01-09 10:30:00	MSFT	Stock	19.79	19.88	19.67	19.82	2729352.0
2009-01-09 11:00:00	MSFT	Stock	19.82	19.86	19.74	19.835	2487158.0
2009-01-09 11:30:00	MSFT	Stock	19.83	19.86	19.65	19.76	3987366.0
2009-01-09 12:00:00	MSFT	Stock	19.76	19.81	19.73	19.74	2468616.0
2009-01-09 12:30:00	MSFT	Stock	19.74	19.82	19.72	19.73	2519321.0
2009-01-09 13:00:00	MSFT	Stock	19.728	19.82	19.68	19.73	2049294.0
2009-01-09 13:30:00	MSFT	Stock	19.73	19.78	19.68	19.71	1349227.0
2009-01-09 14:00:00	MSFT	Stock	19.71	19.84	19.71	19.774	1831651.0
2009-01-09 14:30:00	MSFT	Stock	19.77	19.88	19.75	19.76	2646094.0
2009-01-09 15:00:00	MSFT	Stock	19.76	19.81	19.55	19.62	4565694.0
2009-01-09 15:30:00	MSFT	Stock	19.62	19.72	19.41	19.51	8513623.0
2009-01-09 16:00:00	MSFT	Stock	19.51	19.755	19.505	19.52	3636900.0
2009-01-09 16:30:00	MSFT	Stock	19.52	19.59	19.52	19.55	265896.0
2009-01-09 17:00:00	MSFT	Stock	19.59	19.59	19.52	19.56	17781.0
2009-01-09 17:30:00	MSFT	Stock	19.59	19.59	19.57	19.57	5170.0
2009-01-09 18:00:00	MSFT	Stock	19.56	19.56	19.53	19.55	3095.0
2009-01-09 18:30:00	MSFT	Stock	19.56	19.64	19.56	19.64	5204.0
2009-01-09 19:00:00	MSFT	Stock	19.63	19.63	19.61	19.61	570.0

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

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