PREVIEW / stock_30min / 2009-02-19

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-02-19.parquet
  size:    1.2 MB
  rows:    68,054
  symbols: 3,323

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-02-19 07:00:00	AAPL	Stock	3.3168	3.3214	3.3157	3.3214	189000.0
2009-02-19 07:30:00	AAPL	Stock	3.3214	3.3339	3.3179	3.3214	599704.0
2009-02-19 08:00:00	AAPL	Stock	3.3261	3.3704	3.3214	3.3214	1303316.0
2009-02-19 08:30:00	AAPL	Stock	3.3243	3.3704	3.3218	3.3443	3045952.0
2009-02-19 09:00:00	AAPL	Stock	3.3421	3.3568	3.3264	3.3332	2965760.0
2009-02-19 09:30:00	AAPL	Stock	3.3346	3.3661	3.2775	3.3096	133288876.0
2009-02-19 10:00:00	AAPL	Stock	3.3096	3.3189	3.2782	3.2914	80291176.0
2009-02-19 10:30:00	AAPL	Stock	3.2914	3.2929	3.2482	3.2489	81743704.0
2009-02-19 11:00:00	AAPL	Stock	3.2482	3.2768	3.2461	3.2679	58153760.0
2009-02-19 11:30:00	AAPL	Stock	3.2682	3.2686	3.2346	3.2454	57594208.0
2009-02-19 12:00:00	AAPL	Stock	3.2454	3.2471	3.2261	3.2343	45151176.0
2009-02-19 12:30:00	AAPL	Stock	3.2336	3.2589	3.2321	3.2454	37700628.0
2009-02-19 13:00:00	AAPL	Stock	3.2454	3.2586	3.2311	3.2536	38829168.0
2009-02-19 13:30:00	AAPL	Stock	3.2539	3.2539	3.2264	3.2311	35132412.0
2009-02-19 14:00:00	AAPL	Stock	3.2311	3.2479	3.2268	3.2434	40445496.0
2009-02-19 14:30:00	AAPL	Stock	3.2434	3.2471	3.2243	3.2375	49623644.0
2009-02-19 15:00:00	AAPL	Stock	3.2375	3.2454	3.2189	3.2404	59683820.0
2009-02-19 15:30:00	AAPL	Stock	3.24	3.3019	3.2182	3.2371	95153800.0
2009-02-19 16:00:00	AAPL	Stock	3.2371	3.2607	3.2296	3.2357	31608136.0
2009-02-19 16:30:00	AAPL	Stock	3.2346	3.2371	3.2339	3.2339	14903980.0
2009-02-19 17:00:00	AAPL	Stock	3.2393	3.2479	3.2236	3.2321	342972.0
2009-02-19 17:30:00	AAPL	Stock	3.2336	3.2336	3.2321	3.2321	8400.0
2009-02-19 18:00:00	AAPL	Stock	3.2371	3.2371	3.2329	3.2339	20821052.0
2009-02-19 18:30:00	AAPL	Stock	3.2393	3.2393	3.2268	3.2268	109200.0
2009-02-19 19:00:00	AAPL	Stock	3.2293	3.2336	3.2293	3.2314	65800.0
2009-02-19 19:30:00	AAPL	Stock	3.2314	3.2314	3.225	3.225	127484.0
2009-02-19 07:30:00	MSFT	Stock	18.32	18.32	18.2	18.26	1021.0
2009-02-19 08:00:00	MSFT	Stock	18.12	18.28	18.12	18.27	134826.0
2009-02-19 08:30:00	MSFT	Stock	18.25	18.33	18.12	18.33	236811.0
2009-02-19 09:00:00	MSFT	Stock	18.3	18.4	18.23	18.33	89159.0
2009-02-19 09:30:00	MSFT	Stock	18.3	18.38	18.08	18.14	6158854.0
2009-02-19 10:00:00	MSFT	Stock	18.15	18.16	18.04	18.1	3776378.0
2009-02-19 10:30:00	MSFT	Stock	18.1	18.11	18.0	18.009	2696082.0
2009-02-19 11:00:00	MSFT	Stock	18.005	18.11	17.99	18.05	2439779.0
2009-02-19 11:30:00	MSFT	Stock	18.05	18.05	17.93	17.931	2642390.0
2009-02-19 12:00:00	MSFT	Stock	17.94	17.95	17.81	17.89	2912830.0
2009-02-19 12:30:00	MSFT	Stock	17.89	18.0	17.87	17.922	2206125.0
2009-02-19 13:00:00	MSFT	Stock	17.93	18.02	17.87	18.01	2341654.0
2009-02-19 13:30:00	MSFT	Stock	18.0	18.02	17.92	17.94	1762631.0
2009-02-19 14:00:00	MSFT	Stock	17.94	18.0	17.93	17.95	2629463.0
2009-02-19 14:30:00	MSFT	Stock	17.94	18.0	17.9	17.972	2998048.0
2009-02-19 15:00:00	MSFT	Stock	17.98	18.02	17.89	17.96	4410366.0
2009-02-19 15:30:00	MSFT	Stock	17.97	18.02	17.87	17.91	7730390.0
2009-02-19 16:00:00	MSFT	Stock	17.91	18.009	17.82	17.91	2966999.0
2009-02-19 16:30:00	MSFT	Stock	17.93	17.936	17.87	17.936	211093.0
2009-02-19 17:00:00	MSFT	Stock	17.9	17.9	17.87	17.9	2166.0
2009-02-19 17:30:00	MSFT	Stock	17.89	17.89	17.86	17.89	1174.0
2009-02-19 18:00:00	MSFT	Stock	17.91	17.91	17.87	17.87	458725.0
2009-02-19 18:30:00	MSFT	Stock	17.9	17.9	17.9	17.9	140.0
2009-02-19 19:00:00	MSFT	Stock	17.9	17.9	17.9	17.9	100.0

> showing 50 of 68,054 rows — these rows as CSV

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