PREVIEW / stock_30min / 2010-06-01

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-06-01.parquet
  size:    1.4 MB
  rows:    78,526
  symbols: 3,446

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
2010-06-01 04:00:00	AAPL	Stock	9.1714	9.1771	9.1625	9.1679	109200.0
2010-06-01 04:30:00	AAPL	Stock	9.1679	9.1739	9.1214	9.1571	86520.0
2010-06-01 05:00:00	AAPL	Stock	9.1211	9.1214	9.1211	9.1214	7728.0
2010-06-01 05:30:00	AAPL	Stock	9.1304	9.1304	9.125	9.125	11200.0
2010-06-01 06:00:00	AAPL	Stock	9.1321	9.1429	9.1321	9.1429	38276.0
2010-06-01 06:30:00	AAPL	Stock	9.175	9.175	9.1464	9.1464	31948.0
2010-06-01 07:00:00	AAPL	Stock	9.175	9.1986	9.1743	9.1964	663852.0
2010-06-01 07:30:00	AAPL	Stock	9.1879	9.2393	9.1879	9.2357	419748.0
2010-06-01 08:00:00	AAPL	Stock	9.2296	9.2657	9.1743	9.25	3947384.0
2010-06-01 08:30:00	AAPL	Stock	9.2471	9.2568	9.2375	9.2539	1967616.0
2010-06-01 09:00:00	AAPL	Stock	9.2536	9.2775	9.1743	9.2746	3539564.0
2010-06-01 09:30:00	AAPL	Stock	9.2743	9.3643	9.2486	9.3332	122750292.0
2010-06-01 10:00:00	AAPL	Stock	9.3354	9.4636	9.3321	9.4539	110280828.0
2010-06-01 10:30:00	AAPL	Stock	9.4554	9.4711	9.4114	9.4171	68430012.0
2010-06-01 11:00:00	AAPL	Stock	9.4179	9.4268	9.3968	9.4157	39837756.0
2010-06-01 11:30:00	AAPL	Stock	9.4146	9.4286	9.3643	9.3754	48883660.0
2010-06-01 12:00:00	AAPL	Stock	9.3764	9.4357	9.3686	9.4329	37538312.0
2010-06-01 12:30:00	AAPL	Stock	9.4327	9.4464	9.4161	9.4189	33187952.0
2010-06-01 13:00:00	AAPL	Stock	9.4161	9.4882	9.4161	9.4829	45341856.0
2010-06-01 13:30:00	AAPL	Stock	9.4832	9.4979	9.4246	9.4357	55119316.0
2010-06-01 14:00:00	AAPL	Stock	9.4332	9.4532	9.3929	9.4429	53935728.0
2010-06-01 14:30:00	AAPL	Stock	9.445	9.4643	9.4107	9.4389	39963588.0
2010-06-01 15:00:00	AAPL	Stock	9.4393	9.4475	9.3518	9.3789	71102696.0
2010-06-01 15:30:00	AAPL	Stock	9.3789	9.4104	9.2957	9.3143	112002100.0
2010-06-01 16:00:00	AAPL	Stock	9.3143	9.3175	9.2746	9.3125	13656216.0
2010-06-01 16:30:00	AAPL	Stock	9.3125	9.3282	9.3018	9.3282	1233148.0
2010-06-01 17:00:00	AAPL	Stock	9.3286	9.3375	9.3143	9.3143	1782564.0
2010-06-01 17:30:00	AAPL	Stock	9.3079	9.3339	9.3054	9.3275	783832.0
2010-06-01 18:00:00	AAPL	Stock	9.3268	9.3336	9.3154	9.3279	549080.0
2010-06-01 18:30:00	AAPL	Stock	9.3293	9.3375	9.3236	9.3321	356328.0
2010-06-01 19:00:00	AAPL	Stock	9.3304	9.3379	9.3304	9.3354	188468.0
2010-06-01 19:30:00	AAPL	Stock	9.3364	9.3482	9.3311	9.3479	712208.0
2010-06-01 04:30:00	MSFT	Stock	25.68	25.68	25.66	25.66	1200.0
2010-06-01 06:30:00	MSFT	Stock	25.5	25.5	25.5	25.5	115.0
2010-06-01 07:00:00	MSFT	Stock	25.54	25.55	25.5	25.5	5265.0
2010-06-01 07:30:00	MSFT	Stock	25.5	25.5	25.5	25.5	500.0
2010-06-01 08:00:00	MSFT	Stock	25.57	25.8	25.49	25.5	28340.0
2010-06-01 08:30:00	MSFT	Stock	25.55	25.61	25.51	25.53	9900.0
2010-06-01 09:00:00	MSFT	Stock	25.52	25.8	25.52	25.53	40717.0
2010-06-01 09:30:00	MSFT	Stock	25.53	25.89	25.52	25.81	7064185.0
2010-06-01 10:00:00	MSFT	Stock	25.81	26.17	25.802	26.12	5755993.0
2010-06-01 10:30:00	MSFT	Stock	26.12	26.19	25.97	26.032	5151650.0
2010-06-01 11:00:00	MSFT	Stock	26.03	26.08	25.94	26.045	3074917.0
2010-06-01 11:30:00	MSFT	Stock	26.04	26.07	25.87	25.93	3627670.0
2010-06-01 12:00:00	MSFT	Stock	25.92	26.13	25.9	26.12	3851278.0
2010-06-01 12:30:00	MSFT	Stock	26.12	26.15	26.09	26.115	2546106.0
2010-06-01 13:00:00	MSFT	Stock	26.11	26.26	26.11	26.23	2525104.0
2010-06-01 13:30:00	MSFT	Stock	26.23	26.26	26.19	26.2	3152418.0
2010-06-01 14:00:00	MSFT	Stock	26.2	26.25	26.14	26.23	7323159.0
2010-06-01 14:30:00	MSFT	Stock	26.24	26.31	26.211	26.3	5986387.0

> showing 50 of 78,526 rows — these rows as CSV

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