PREVIEW / stock_30min / 2008-08-18

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-08-18.parquet
  size:    1.2 MB
  rows:    68,482
  symbols: 3,313

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-08-18 04:00:00	AAPL	Stock	6.25	6.25	6.25	6.25	7000.0
2008-08-18 07:00:00	AAPL	Stock	6.2993	6.3121	6.2964	6.3071	131712.0
2008-08-18 07:30:00	AAPL	Stock	6.3089	6.3143	6.3036	6.3036	117824.0
2008-08-18 08:00:00	AAPL	Stock	6.3036	6.3104	6.2914	6.2982	304472.0
2008-08-18 08:30:00	AAPL	Stock	6.295	6.295	6.2682	6.2932	1343440.0
2008-08-18 09:00:00	AAPL	Stock	6.2936	6.2993	6.2625	6.2639	1633884.0
2008-08-18 09:30:00	AAPL	Stock	6.2671	6.3286	6.2589	6.3214	81038944.0
2008-08-18 10:00:00	AAPL	Stock	6.3236	6.3279	6.2646	6.2921	59623452.0
2008-08-18 10:30:00	AAPL	Stock	6.2914	6.3504	6.2861	6.3368	46124708.0
2008-08-18 11:00:00	AAPL	Stock	6.3382	6.3496	6.3221	6.3304	27806604.0
2008-08-18 11:30:00	AAPL	Stock	6.3336	6.3368	6.2932	6.2936	21531104.0
2008-08-18 12:00:00	AAPL	Stock	6.2936	6.3071	6.2689	6.2868	36397256.0
2008-08-18 12:30:00	AAPL	Stock	6.2875	6.2971	6.2589	6.263	29167320.0
2008-08-18 13:00:00	AAPL	Stock	6.263	6.3018	6.263	6.2968	24624264.0
2008-08-18 13:30:00	AAPL	Stock	6.2961	6.2975	6.2536	6.2629	23601704.0
2008-08-18 14:00:00	AAPL	Stock	6.2629	6.2896	6.2596	6.2879	27930728.0
2008-08-18 14:30:00	AAPL	Stock	6.2879	6.2889	6.2554	6.2596	26431496.0
2008-08-18 15:00:00	AAPL	Stock	6.2606	6.2606	6.2079	6.2246	65622648.0
2008-08-18 15:30:00	AAPL	Stock	6.2246	6.2739	6.2143	6.265	51458960.0
2008-08-18 16:00:00	AAPL	Stock	6.2671	6.2813	6.2333	6.2732	18185608.0
2008-08-18 16:30:00	AAPL	Stock	6.2743	6.2786	6.2714	6.2743	285376.0
2008-08-18 17:00:00	AAPL	Stock	6.2718	6.2718	6.2714	6.2714	138488.0
2008-08-18 17:30:00	AAPL	Stock	6.2682	6.2682	6.2643	6.2675	112700.0
2008-08-18 18:00:00	AAPL	Stock	6.2577	6.275	6.2577	6.275	35840.0
2008-08-18 18:30:00	AAPL	Stock	6.275	6.2818	6.2714	6.2779	155344.0
2008-08-18 19:00:00	AAPL	Stock	6.2814	6.2821	6.2786	6.2786	47292.0
2008-08-18 19:30:00	AAPL	Stock	6.2836	6.2893	6.2786	6.2893	332192.0
2008-08-18 08:00:00	MSFT	Stock	27.81	27.81	27.81	27.81	100.0
2008-08-18 08:30:00	MSFT	Stock	27.91	27.91	27.85	27.85	200.0
2008-08-18 09:00:00	MSFT	Stock	27.89	27.89	27.8	27.8	10100.0
2008-08-18 09:30:00	MSFT	Stock	27.83	27.98	27.78	27.96	3979715.0
2008-08-18 10:00:00	MSFT	Stock	27.96	27.96	27.79	27.83	2966459.0
2008-08-18 10:30:00	MSFT	Stock	27.83	27.98	27.8	27.96	2741620.0
2008-08-18 11:00:00	MSFT	Stock	27.95	28.05	27.91	27.94	1912295.0
2008-08-18 11:30:00	MSFT	Stock	27.95	27.98	27.77	27.77	1358805.0
2008-08-18 12:00:00	MSFT	Stock	27.77	27.79	27.67	27.775	3115829.0
2008-08-18 12:30:00	MSFT	Stock	27.78	27.79	27.63	27.649	1721736.0
2008-08-18 13:00:00	MSFT	Stock	27.65	27.74	27.63	27.69	1277374.0
2008-08-18 13:30:00	MSFT	Stock	27.698	27.72	27.58	27.6	1584076.0
2008-08-18 14:00:00	MSFT	Stock	27.6	27.68	27.575	27.66	1426978.0
2008-08-18 14:30:00	MSFT	Stock	27.65	27.66	27.59	27.66	1688728.0
2008-08-18 15:00:00	MSFT	Stock	27.652	27.76	27.55	27.69	3995829.0
2008-08-18 15:30:00	MSFT	Stock	27.69	27.75	27.55	27.71	4601685.0
2008-08-18 16:00:00	MSFT	Stock	27.73	27.894	27.601	27.83	2981365.0
2008-08-18 16:30:00	MSFT	Stock	27.69	27.712	27.69	27.69	1701560.0
2008-08-18 17:00:00	MSFT	Stock	27.77	27.77	27.77	27.77	100.0
2008-08-18 17:30:00	MSFT	Stock	27.77	27.77	27.75	27.76	970.0
2008-08-18 18:00:00	MSFT	Stock	27.638	27.76	27.638	27.69	30909.0
2008-08-18 18:30:00	MSFT	Stock	27.76	27.77	27.76	27.77	740.0
2008-08-18 19:30:00	MSFT	Stock	27.76	27.77	27.76	27.77	4490.0

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

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