PREVIEW / etf_30min / 2008-05-27

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-05-27.parquet
  size:    164 KB
  rows:    5,620

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-27 06:00:00	SPY	ETF	137.69	137.69	137.69	137.69	1000.0
2008-05-27 06:30:00	SPY	ETF	137.55	137.55	137.45	137.55	27100.0
2008-05-27 07:00:00	SPY	ETF	137.48	137.48	137.32	137.44	279500.0
2008-05-27 07:30:00	SPY	ETF	137.46	137.55	137.4	137.51	80100.0
2008-05-27 08:00:00	SPY	ETF	137.5	137.56	137.4	137.4	395585.0
2008-05-27 08:30:00	SPY	ETF	137.39	137.95	137.39	137.62	609672.0
2008-05-27 09:00:00	SPY	ETF	137.62	137.98	137.54	137.81	1636281.0
2008-05-27 09:30:00	SPY	ETF	137.8	138.41	137.8	138.14	20638635.0
2008-05-27 10:00:00	SPY	ETF	138.13	138.66	137.89	138.295	19497624.0
2008-05-27 10:30:00	SPY	ETF	138.3	138.4	138.12	138.35	7658875.0
2008-05-27 11:00:00	SPY	ETF	138.35	138.49	137.8	137.88	9964576.0
2008-05-27 11:30:00	SPY	ETF	137.87	137.97	137.63	137.66	7918880.0
2008-05-27 12:00:00	SPY	ETF	137.66	137.96	137.53	137.93	8848057.0
2008-05-27 12:30:00	SPY	ETF	137.94	138.1	137.85	138.06	6033226.0
2008-05-27 13:00:00	SPY	ETF	138.07	138.0801	137.8	137.99	5016123.0
2008-05-27 13:30:00	SPY	ETF	137.98	138.23	137.87	138.19	5442072.0
2008-05-27 14:00:00	SPY	ETF	138.195	138.33	138.06	138.13	8783259.0
2008-05-27 14:30:00	SPY	ETF	138.13	138.82	138.13	138.73	14166789.0
2008-05-27 15:00:00	SPY	ETF	138.73	138.87	138.63	138.78	10525881.0
2008-05-27 15:30:00	SPY	ETF	138.755	139.0	138.62	138.74	22727189.0
2008-05-27 16:00:00	SPY	ETF	138.74	138.82	137.8245	138.71	8754694.0
2008-05-27 16:30:00	SPY	ETF	137.82	138.76	137.82	138.76	2064038.0
2008-05-27 17:00:00	SPY	ETF	138.73	138.73	137.82	138.72	1045000.0
2008-05-27 17:30:00	SPY	ETF	138.7	138.74	138.66	138.66	1500700.0
2008-05-27 18:00:00	SPY	ETF	138.73	138.75	138.73	138.75	2000.0
2008-05-27 18:30:00	SPY	ETF	138.73	138.75	138.73	138.73	1400.0
2008-05-27 19:00:00	SPY	ETF	138.7	138.73	138.68	138.73	4670.0
2008-05-27 19:30:00	SPY	ETF	138.72	138.76	138.72	138.74	7600.0
2008-05-27 07:00:00	QQQ	ETF	48.18	48.18	48.09	48.16	118000.0
2008-05-27 07:30:00	QQQ	ETF	48.14	48.21	48.14	48.2	61050.0
2008-05-27 08:00:00	QQQ	ETF	48.19	48.2	48.13	48.14	129640.0
2008-05-27 08:30:00	QQQ	ETF	48.14	48.27	48.14	48.26	334177.0
2008-05-27 09:00:00	QQQ	ETF	48.27	48.39	48.25	48.33	1251648.0
2008-05-27 09:30:00	QQQ	ETF	48.32	48.71	48.29	48.56	15283441.0
2008-05-27 10:00:00	QQQ	ETF	48.55	48.8	48.5	48.68	12526746.0
2008-05-27 10:30:00	QQQ	ETF	48.675	48.74	48.57	48.72	6116528.0
2008-05-27 11:00:00	QQQ	ETF	48.72	48.78	48.46	48.51	5610492.0
2008-05-27 11:30:00	QQQ	ETF	48.51	48.53	48.379	48.38	4089678.0
2008-05-27 12:00:00	QQQ	ETF	48.38	48.5	48.31	48.48	4216651.0
2008-05-27 12:30:00	QQQ	ETF	48.49	48.54	48.45	48.52	2332519.0
2008-05-27 13:00:00	QQQ	ETF	48.5299	48.6	48.48	48.57	4031221.0
2008-05-27 13:30:00	QQQ	ETF	48.56	48.7101	48.53	48.7	5802083.0
2008-05-27 14:00:00	QQQ	ETF	48.71	48.77	48.65	48.67	5603099.0
2008-05-27 14:30:00	QQQ	ETF	48.6799	49.05	48.67	48.99	14885217.0
2008-05-27 15:00:00	QQQ	ETF	48.9899	49.07	48.95	49.04	6810496.0
2008-05-27 15:30:00	QQQ	ETF	49.04	49.11	48.97	49.079	9227795.0
2008-05-27 16:00:00	QQQ	ETF	49.07	49.1185	48.722	49.02	3947737.0
2008-05-27 16:30:00	QQQ	ETF	49.01	49.01	48.99	49.0	66800.0
2008-05-27 17:00:00	QQQ	ETF	49.0	49.02	48.98	49.02	195773.0
2008-05-27 17:30:00	QQQ	ETF	49.01	49.01	49.0	49.01	59491.0

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

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