PREVIEW / etf_30min / 2008-05-01

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-05-01.parquet
  size:    169 KB
  rows:    5,774

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-05-01 05:00:00	SPY	ETF	138.69	138.69	138.69	138.69	1000.0
2008-05-01 06:00:00	SPY	ETF	138.8	138.8	138.76	138.8	78800.0
2008-05-01 06:30:00	SPY	ETF	138.8	138.9	138.8	138.85	79500.0
2008-05-01 07:00:00	SPY	ETF	138.9	138.92	138.8	138.88	216684.0
2008-05-01 07:30:00	SPY	ETF	138.89	138.91	138.8	138.91	530947.0
2008-05-01 08:00:00	SPY	ETF	138.88	138.91	138.65	138.79	1208855.0
2008-05-01 08:30:00	SPY	ETF	138.66	138.88	138.26	138.46	2066102.0
2008-05-01 09:00:00	SPY	ETF	138.46	138.5	138.3	138.39	1253969.0
2008-05-01 09:30:00	SPY	ETF	138.39	138.95	138.27	138.75	15175320.0
2008-05-01 10:00:00	SPY	ETF	138.75	139.18	138.68	139.14	20579135.0
2008-05-01 10:30:00	SPY	ETF	139.15	139.17	138.83	139.0999	11190281.0
2008-05-01 11:00:00	SPY	ETF	139.09	139.42	138.98	139.26	11750515.0
2008-05-01 11:30:00	SPY	ETF	139.26	139.52	139.2	139.28	7729349.0
2008-05-01 12:00:00	SPY	ETF	139.29	139.74	139.28	139.63	7910114.0
2008-05-01 12:30:00	SPY	ETF	139.64	140.61	139.64	140.45	18481759.0
2008-05-01 13:00:00	SPY	ETF	140.45	141.0	140.24	140.67	19423596.0
2008-05-01 13:30:00	SPY	ETF	140.67	140.7	140.31	140.35	8369262.0
2008-05-01 14:00:00	SPY	ETF	140.35	140.74	140.24	140.49	13110159.0
2008-05-01 14:30:00	SPY	ETF	140.47	141.0	140.46	140.622	12012727.0
2008-05-01 15:00:00	SPY	ETF	140.62	140.8	140.48	140.71	10067079.0
2008-05-01 15:30:00	SPY	ETF	140.71	141.02	140.36	140.94	18533185.0
2008-05-01 16:00:00	SPY	ETF	140.9	141.17	140.7	141.08	2708358.0
2008-05-01 16:30:00	SPY	ETF	141.08	141.12	141.03	141.05	283281.0
2008-05-01 17:00:00	SPY	ETF	141.04	141.12	141.03	141.07	139535.0
2008-05-01 17:30:00	SPY	ETF	141.07	141.07	140.2424	141.04	140200.0
2008-05-01 18:00:00	SPY	ETF	141.05	141.05	141.0	141.02	14442.0
2008-05-01 18:30:00	SPY	ETF	141.03	141.12	141.01	141.12	6420.0
2008-05-01 19:00:00	SPY	ETF	141.12	141.14	141.06	141.12	7500.0
2008-05-01 19:30:00	SPY	ETF	141.08	141.13	141.08	141.13	6800.0
2008-05-01 06:30:00	QQQ	ETF	47.28	47.28	47.28	47.28	100.0
2008-05-01 07:00:00	QQQ	ETF	47.3	47.39	47.3	47.39	101000.0
2008-05-01 07:30:00	QQQ	ETF	47.33	47.35	47.31	47.32	72443.0
2008-05-01 08:00:00	QQQ	ETF	47.32	47.38	47.29	47.35	669223.0
2008-05-01 08:30:00	QQQ	ETF	47.31	47.35	47.21	47.28	772925.0
2008-05-01 09:00:00	QQQ	ETF	47.29	47.29	47.15	47.24	853766.0
2008-05-01 09:30:00	QQQ	ETF	47.24	47.65	47.22	47.61	14544197.0
2008-05-01 10:00:00	QQQ	ETF	47.61	47.97	47.61	47.9625	16193735.0
2008-05-01 10:30:00	QQQ	ETF	47.96	48.01	47.82	48.01	8455104.0
2008-05-01 11:00:00	QQQ	ETF	48.01	48.24	47.985	48.07	12055377.0
2008-05-01 11:30:00	QQQ	ETF	48.07	48.23	48.04	48.12	5167026.0
2008-05-01 12:00:00	QQQ	ETF	48.12	48.39	48.12	48.299	7195606.0
2008-05-01 12:30:00	QQQ	ETF	48.29	48.52	48.29	48.44	9318139.0
2008-05-01 13:00:00	QQQ	ETF	48.44	48.55	48.33	48.4475	8042879.0
2008-05-01 13:30:00	QQQ	ETF	48.4425	48.49	48.31	48.36	5856134.0
2008-05-01 14:00:00	QQQ	ETF	48.3525	48.49	48.3	48.35	8065087.0
2008-05-01 14:30:00	QQQ	ETF	48.35	48.58	48.34	48.45	8965192.0
2008-05-01 15:00:00	QQQ	ETF	48.441	48.51	48.36	48.4899	7323708.0
2008-05-01 15:30:00	QQQ	ETF	48.4899	48.72	48.39	48.69	11935163.0
2008-05-01 16:00:00	QQQ	ETF	48.682	48.73	48.5192	48.65	8689680.0
2008-05-01 16:30:00	QQQ	ETF	48.69	48.72	48.67	48.69	241385.0

> showing 50 of 5,774 rows — these rows as CSV

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