PREVIEW / etf_30min / 2008-06-23

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-06-23.parquet
  size:    168 KB
  rows:    5,881

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-06-23 04:30:00	SPY	ETF	132.11	132.14	132.04	132.05	3000.0
2008-06-23 05:00:00	SPY	ETF	131.99	132.0	131.77	132.0	51200.0
2008-06-23 05:30:00	SPY	ETF	131.96	131.96	131.96	131.96	400.0
2008-06-23 06:00:00	SPY	ETF	132.06	132.23	132.06	132.23	4900.0
2008-06-23 06:30:00	SPY	ETF	132.23	132.28	132.11	132.11	379700.0
2008-06-23 07:00:00	SPY	ETF	132.11	132.11	131.87	131.98	340600.0
2008-06-23 07:30:00	SPY	ETF	131.95	132.03	131.7	131.75	648955.0
2008-06-23 08:00:00	SPY	ETF	131.76	132.13	131.76	132.0	1298668.0
2008-06-23 08:30:00	SPY	ETF	132.0	132.4	131.92	132.37	2271777.0
2008-06-23 09:00:00	SPY	ETF	132.37	132.47	132.04	132.04	2313085.0
2008-06-23 09:30:00	SPY	ETF	132.04	132.23	131.63	131.78	19524884.0
2008-06-23 10:00:00	SPY	ETF	131.77	131.96	131.44	131.72	16254531.0
2008-06-23 10:30:00	SPY	ETF	131.73	132.1	131.46	131.71	12517852.0
2008-06-23 11:00:00	SPY	ETF	131.7	131.8	131.32	131.51	12744442.0
2008-06-23 11:30:00	SPY	ETF	131.51	131.75	131.39	131.68	9951310.0
2008-06-23 12:00:00	SPY	ETF	131.68	131.76	131.34	131.36	6855107.0
2008-06-23 12:30:00	SPY	ETF	131.35	131.75	131.35	131.71	6417005.0
2008-06-23 13:00:00	SPY	ETF	131.7	131.94	131.53	131.79	10161131.0
2008-06-23 13:30:00	SPY	ETF	131.8	132.09	131.72	131.93	7619945.0
2008-06-23 14:00:00	SPY	ETF	131.93	132.05	131.67	131.7701	11849973.0
2008-06-23 14:30:00	SPY	ETF	131.78	131.91	131.53	131.64	8186424.0
2008-06-23 15:00:00	SPY	ETF	131.63	131.7	131.38	131.65	10310352.0
2008-06-23 15:30:00	SPY	ETF	131.65	131.7	131.36	131.63	13071308.0
2008-06-23 16:00:00	SPY	ETF	131.62	131.66	131.27	131.34	2675702.0
2008-06-23 16:30:00	SPY	ETF	131.4	131.9937	131.14	131.33	4498321.0
2008-06-23 17:00:00	SPY	ETF	131.33	131.45	131.29	131.4	1302188.0
2008-06-23 17:30:00	SPY	ETF	131.4	131.47	131.34	131.39	85700.0
2008-06-23 18:00:00	SPY	ETF	131.37	131.37	131.33	131.34	7881.0
2008-06-23 18:30:00	SPY	ETF	131.33	131.36	131.32	131.33	12954.0
2008-06-23 19:00:00	SPY	ETF	131.3	131.35	131.3	131.35	700.0
2008-06-23 19:30:00	SPY	ETF	131.31	131.36	131.31	131.36	4400.0
2008-06-23 06:30:00	QQQ	ETF	47.73	47.76	47.69	47.69	51700.0
2008-06-23 07:00:00	QQQ	ETF	47.68	47.68	47.63	47.63	251247.0
2008-06-23 07:30:00	QQQ	ETF	47.65	47.65	47.48	47.51	641795.0
2008-06-23 08:00:00	QQQ	ETF	47.51	47.63	47.5	47.55	2469518.0
2008-06-23 08:30:00	QQQ	ETF	47.54	47.71	47.51	47.69	2404988.0
2008-06-23 09:00:00	QQQ	ETF	47.7	47.73	47.6	47.62	636629.0
2008-06-23 09:30:00	QQQ	ETF	47.62	47.74	47.31	47.37	16336780.0
2008-06-23 10:00:00	QQQ	ETF	47.38	47.52	47.25	47.39	9697513.0
2008-06-23 10:30:00	QQQ	ETF	47.39	47.51	47.07	47.19	12864979.0
2008-06-23 11:00:00	QQQ	ETF	47.18	47.24	46.98	47.12	10125923.0
2008-06-23 11:30:00	QQQ	ETF	47.12	47.27	47.09	47.27	8267452.0
2008-06-23 12:00:00	QQQ	ETF	47.271	47.3	47.06	47.09	6672924.0
2008-06-23 12:30:00	QQQ	ETF	47.08	47.29	47.07	47.26	4938390.0
2008-06-23 13:00:00	QQQ	ETF	47.26	47.33	47.17	47.3099	6013109.0
2008-06-23 13:30:00	QQQ	ETF	47.3	47.55	47.28	47.4199	9413197.0
2008-06-23 14:00:00	QQQ	ETF	47.41	47.52	47.36	47.5	7239998.0
2008-06-23 14:30:00	QQQ	ETF	47.49	47.54	47.27	47.3301	4309739.0
2008-06-23 15:00:00	QQQ	ETF	47.34	47.35	47.11	47.23	5010175.0
2008-06-23 15:30:00	QQQ	ETF	47.23	47.25	47.01	47.059	10990084.0

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

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