PREVIEW / stock_30min / 2007-08-16

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-08-16.parquet
  size:    1.2 MB
  rows:    68,610
  symbols: 3,145

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
2007-08-16 09:30:00	AAPL	Stock	4.1789	4.2321	4.1375	4.1407	210793744.0
2007-08-16 10:00:00	AAPL	Stock	4.1406	4.1446	3.9864	4.0296	225672860.0
2007-08-16 10:30:00	AAPL	Stock	4.0286	4.1139	3.9982	4.0757	171975468.0
2007-08-16 11:00:00	AAPL	Stock	4.075	4.1336	4.0575	4.085	112550816.0
2007-08-16 11:30:00	AAPL	Stock	4.0871	4.0957	4.0411	4.0664	111627600.0
2007-08-16 12:00:00	AAPL	Stock	4.065	4.0664	4.0211	4.0425	97943664.0
2007-08-16 12:30:00	AAPL	Stock	4.0425	4.0657	4.0	4.0068	106755936.0
2007-08-16 13:00:00	AAPL	Stock	4.0071	4.0754	3.9871	4.0545	101042340.0
2007-08-16 13:30:00	AAPL	Stock	4.055	4.1393	4.0476	4.1232	120125292.0
2007-08-16 14:00:00	AAPL	Stock	4.1243	4.175	4.0954	4.1164	114292556.0
2007-08-16 14:30:00	AAPL	Stock	4.1179	4.1429	4.0804	4.1189	84381640.0
2007-08-16 15:00:00	AAPL	Stock	4.1196	4.1243	4.0214	4.0957	102469164.0
2007-08-16 15:30:00	AAPL	Stock	4.0954	4.2093	4.0875	4.1893	155011472.0
2007-08-16 16:00:00	AAPL	Stock	4.1886	4.1907	4.1804	4.1804	22691704.0
2007-08-16 09:30:00	MSFT	Stock	27.88	28.15	27.8	27.91	6093833.0
2007-08-16 10:00:00	MSFT	Stock	27.9	28.13	27.89	28.0	4055832.0
2007-08-16 10:30:00	MSFT	Stock	27.99	28.35	27.98	28.17	4201184.0
2007-08-16 11:00:00	MSFT	Stock	28.16	28.34	28.04	28.05	3457164.0
2007-08-16 11:30:00	MSFT	Stock	28.06	28.11	27.85	28.0	3702197.0
2007-08-16 12:00:00	MSFT	Stock	28.0	28.0	27.63	27.89	5090493.0
2007-08-16 12:30:00	MSFT	Stock	27.89	28.01	27.51	27.6	5038558.0
2007-08-16 13:00:00	MSFT	Stock	27.6	27.87	27.52	27.732	3695548.0
2007-08-16 13:30:00	MSFT	Stock	27.73	28.0	27.68	27.84	4382264.0
2007-08-16 14:00:00	MSFT	Stock	27.84	28.04	27.68	27.87	5028373.0
2007-08-16 14:30:00	MSFT	Stock	27.88	28.03	27.69	27.76	3998878.0
2007-08-16 15:00:00	MSFT	Stock	27.76	27.8	27.51	27.739	5888788.0
2007-08-16 15:30:00	MSFT	Stock	27.74	27.97	27.65	27.84	10890739.0
2007-08-16 16:00:00	MSFT	Stock	27.84	27.86	27.81	27.81	3373194.0
2007-08-16 07:30:00	NVDA	Stock	0.7133	0.7133	0.7133	0.7133	6000.0
2007-08-16 08:00:00	NVDA	Stock	0.7103	0.7167	0.7017	0.705	449700.0
2007-08-16 08:30:00	NVDA	Stock	0.7058	0.7133	0.7033	0.7115	524040.0
2007-08-16 09:00:00	NVDA	Stock	0.7122	0.7208	0.7122	0.7142	433980.0
2007-08-16 09:30:00	NVDA	Stock	0.7137	0.7195	0.7075	0.7143	81567360.0
2007-08-16 10:00:00	NVDA	Stock	0.7143	0.7157	0.7	0.7028	72622920.0
2007-08-16 10:30:00	NVDA	Stock	0.7028	0.7102	0.6977	0.7042	52275060.0
2007-08-16 11:00:00	NVDA	Stock	0.704	0.7117	0.7017	0.71	39495720.0
2007-08-16 11:30:00	NVDA	Stock	0.71	0.7105	0.6983	0.6992	53439840.0
2007-08-16 12:00:00	NVDA	Stock	0.6995	0.6995	0.6917	0.6925	53541000.0
2007-08-16 12:30:00	NVDA	Stock	0.6925	0.6972	0.675	0.6783	58625940.0
2007-08-16 13:00:00	NVDA	Stock	0.6782	0.6855	0.675	0.685	38363280.0
2007-08-16 13:30:00	NVDA	Stock	0.6853	0.7027	0.6823	0.6985	71680560.0
2007-08-16 14:00:00	NVDA	Stock	0.6988	0.7125	0.6935	0.6992	50496840.0
2007-08-16 14:30:00	NVDA	Stock	0.6993	0.707	0.6968	0.7021	40444680.0
2007-08-16 15:00:00	NVDA	Stock	0.702	0.7155	0.6847	0.6972	41894400.0
2007-08-16 15:30:00	NVDA	Stock	0.6973	0.7135	0.6942	0.71	82802640.0
2007-08-16 16:00:00	NVDA	Stock	0.71	0.7167	0.7095	0.715	18041100.0
2007-08-16 16:30:00	NVDA	Stock	0.7145	0.715	0.7102	0.7102	1905720.0
2007-08-16 17:00:00	NVDA	Stock	0.7115	0.7117	0.7115	0.7117	71700.0
2007-08-16 17:30:00	NVDA	Stock	0.7148	0.715	0.7148	0.715	78000.0
2007-08-16 18:00:00	NVDA	Stock	0.7128	0.7128	0.7128	0.7128	18000.0

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

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