PREVIEW / etf_30min / 2008-09-19

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-09-19.parquet
  size:    186 KB
  rows:    6,528

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-09-19 04:00:00	SPY	ETF	122.99	122.99	122.58	122.85	2600.0
2008-09-19 04:30:00	SPY	ETF	122.95	123.57	122.95	123.57	2050.0
2008-09-19 05:00:00	SPY	ETF	123.43	123.7	123.21	123.65	3000.0
2008-09-19 05:30:00	SPY	ETF	123.7	123.85	123.55	123.69	81400.0
2008-09-19 06:00:00	SPY	ETF	123.65	124.02	123.56	123.86	65100.0
2008-09-19 06:30:00	SPY	ETF	123.97	124.36	123.69	123.73	226000.0
2008-09-19 07:00:00	SPY	ETF	123.73	124.1	123.54	123.95	1383507.0
2008-09-19 07:30:00	SPY	ETF	123.99	125.1	123.99	124.71	4486843.0
2008-09-19 08:00:00	SPY	ETF	124.7	125.35	121.2891	124.92	10387137.0
2008-09-19 08:30:00	SPY	ETF	124.92	126.88	123.81	126.51	5717752.0
2008-09-19 09:00:00	SPY	ETF	126.52	128.09	126.45	126.92	4810789.0
2008-09-19 09:30:00	SPY	ETF	126.91	128.0	124.6	124.73	55140881.0
2008-09-19 10:00:00	SPY	ETF	124.74	125.23	123.61	123.99	38044753.0
2008-09-19 10:30:00	SPY	ETF	123.99	124.37	123.33	123.7	30433135.0
2008-09-19 11:00:00	SPY	ETF	123.7	125.03	123.7	124.45	26979677.0
2008-09-19 11:30:00	SPY	ETF	124.45	126.75	124.19	125.4	24472762.0
2008-09-19 12:00:00	SPY	ETF	125.4	127.76	124.71	126.13	24123893.0
2008-09-19 12:30:00	SPY	ETF	126.13	126.4	122.5	125.67	41901709.0
2008-09-19 13:00:00	SPY	ETF	125.67	126.25	125.15	125.56	26458145.0
2008-09-19 13:30:00	SPY	ETF	125.57	125.59	124.81	124.82	13920292.0
2008-09-19 14:00:00	SPY	ETF	124.82	126.25	124.44	124.85	19172975.0
2008-09-19 14:30:00	SPY	ETF	124.85	125.2	124.45	124.83	20660460.0
2008-09-19 15:00:00	SPY	ETF	124.83	125.07	123.52	124.35	36129850.0
2008-09-19 15:30:00	SPY	ETF	124.32	125.23	116.52	125.04	47298377.0
2008-09-19 16:00:00	SPY	ETF	125.02	125.1	122.7091	124.15	15472081.0
2008-09-19 16:30:00	SPY	ETF	124.14	125.34	120.4883	124.39	32568423.0
2008-09-19 17:00:00	SPY	ETF	124.33	124.7	124.28	124.6	5392511.0
2008-09-19 17:30:00	SPY	ETF	124.6	124.7	120.4883	124.6	4104330.0
2008-09-19 18:00:00	SPY	ETF	124.59	124.8	124.53	124.75	28975.0
2008-09-19 18:30:00	SPY	ETF	124.6	124.71	124.53	124.71	10381.0
2008-09-19 19:00:00	SPY	ETF	124.55	124.55	124.53	124.55	29865.0
2008-09-19 19:30:00	SPY	ETF	124.54	124.55	124.3	124.53	9250.0
2008-09-19 04:00:00	QQQ	ETF	42.6	42.6	42.57	42.57	1700.0
2008-09-19 04:30:00	QQQ	ETF	42.56	42.72	42.56	42.72	3800.0
2008-09-19 05:00:00	QQQ	ETF	42.69	42.81	42.65	42.73	3900.0
2008-09-19 05:30:00	QQQ	ETF	42.8	42.8	42.71	42.71	1000.0
2008-09-19 06:00:00	QQQ	ETF	42.75	42.8	42.73	42.8	11700.0
2008-09-19 06:30:00	QQQ	ETF	42.8	42.85	42.69	42.69	12500.0
2008-09-19 07:00:00	QQQ	ETF	42.69	42.83	42.57	42.57	165462.0
2008-09-19 07:30:00	QQQ	ETF	42.57	43.1	42.57	43.01	1278651.0
2008-09-19 08:00:00	QQQ	ETF	43.0	43.65	42.5719	43.54	6811912.0
2008-09-19 08:30:00	QQQ	ETF	43.55	43.75	43.48	43.51	2104173.0
2008-09-19 09:00:00	QQQ	ETF	43.51	44.23	43.51	43.82	2864030.0
2008-09-19 09:30:00	QQQ	ETF	43.82	43.83	42.59	42.6605	44437605.0
2008-09-19 10:00:00	QQQ	ETF	42.66	42.87	42.1	42.62	29593544.0
2008-09-19 10:30:00	QQQ	ETF	42.63	42.68	42.29	42.41	12917553.0
2008-09-19 11:00:00	QQQ	ETF	42.41	43.0	42.41	42.79	17201763.0
2008-09-19 11:30:00	QQQ	ETF	42.8	43.13	42.66	43.0805	16394150.0
2008-09-19 12:00:00	QQQ	ETF	43.09	43.19	42.98	43.19	13497222.0
2008-09-19 12:30:00	QQQ	ETF	43.19	43.28	43.045	43.08	11013113.0

> showing 50 of 6,528 rows — these rows as CSV

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