PREVIEW / etf_30min / 2010-04-26

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-04-26.parquet
  size:    254 KB
  rows:    8,552

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
2010-04-26 04:00:00	SPY	ETF	121.96	122.0	121.94	122.0	2075.0
2010-04-26 04:30:00	SPY	ETF	121.99	122.02	121.99	122.02	2100.0
2010-04-26 05:00:00	SPY	ETF	121.94	121.94	121.84	121.89	1370.0
2010-04-26 05:30:00	SPY	ETF	121.82	121.82	121.76	121.8	500.0
2010-04-26 06:00:00	SPY	ETF	121.73	121.9	121.0	121.84	18900.0
2010-04-26 06:30:00	SPY	ETF	121.84	121.92	121.84	121.89	9240.0
2010-04-26 07:00:00	SPY	ETF	121.93	122.02	121.9	121.9	118374.0
2010-04-26 07:30:00	SPY	ETF	121.9	121.96	121.86	121.91	251475.0
2010-04-26 08:00:00	SPY	ETF	121.9	122.01	121.9	121.94	1503041.0
2010-04-26 08:30:00	SPY	ETF	121.94	121.94	121.76	121.89	896644.0
2010-04-26 09:00:00	SPY	ETF	121.9	121.93	121.79	121.85	1317268.0
2010-04-26 09:30:00	SPY	ETF	121.85	122.1	121.72	121.76	20676458.0
2010-04-26 10:00:00	SPY	ETF	121.75	122.0	121.63	121.76	15212293.0
2010-04-26 10:30:00	SPY	ETF	121.77	122.04	121.66	121.96	12704680.0
2010-04-26 11:00:00	SPY	ETF	121.96	122.12	121.9001	121.94	6557190.0
2010-04-26 11:30:00	SPY	ETF	121.94	121.988	121.71	121.75	6904164.0
2010-04-26 12:00:00	SPY	ETF	121.74	121.84	121.65	121.72	7061685.0
2010-04-26 12:30:00	SPY	ETF	121.71	121.84	121.68	121.82	5188437.0
2010-04-26 13:00:00	SPY	ETF	121.83	121.85	121.74	121.7499	4184041.0
2010-04-26 13:30:00	SPY	ETF	121.745	121.78	121.6	121.6901	7496264.0
2010-04-26 14:00:00	SPY	ETF	121.69	121.89	121.61	121.85	8282917.0
2010-04-26 14:30:00	SPY	ETF	121.8401	121.845	121.58	121.58	5350002.0
2010-04-26 15:00:00	SPY	ETF	121.58	121.83	121.23	121.38	14268762.0
2010-04-26 15:30:00	SPY	ETF	121.39	121.54	121.28	121.34	16844338.0
2010-04-26 16:00:00	SPY	ETF	121.35	122.03	121.21	121.29	5316389.0
2010-04-26 16:30:00	SPY	ETF	121.27	121.32	121.22	121.26	204837.0
2010-04-26 17:00:00	SPY	ETF	121.27	121.28	121.16	121.18	72089.0
2010-04-26 17:30:00	SPY	ETF	121.2	121.22	121.17	121.22	35945.0
2010-04-26 18:00:00	SPY	ETF	121.22	121.32	121.17	121.31	74003.0
2010-04-26 18:30:00	SPY	ETF	121.31	121.31	121.21	121.22	11782.0
2010-04-26 19:00:00	SPY	ETF	121.22	121.22	121.16	121.16	13723.0
2010-04-26 19:30:00	SPY	ETF	121.2	121.29	121.18	121.25	9840.0
2010-04-26 20:00:00	SPY	ETF	121.23	121.23	121.23	121.23	200.0
2010-04-26 04:00:00	QQQ	ETF	50.64	50.64	50.64	50.64	100.0
2010-04-26 04:30:00	QQQ	ETF	50.65	50.65	50.65	50.65	300.0
2010-04-26 06:00:00	QQQ	ETF	50.55	50.55	50.55	50.55	500.0
2010-04-26 06:30:00	QQQ	ETF	50.6	50.63	50.54	50.54	1300.0
2010-04-26 07:00:00	QQQ	ETF	50.55	50.62	50.55	50.6	16126.0
2010-04-26 07:30:00	QQQ	ETF	50.58	50.62	50.58	50.6	13198.0
2010-04-26 08:00:00	QQQ	ETF	50.6	50.62	50.55	50.56	725719.0
2010-04-26 08:30:00	QQQ	ETF	50.57	50.57	50.52	50.57	798939.0
2010-04-26 09:00:00	QQQ	ETF	50.57	50.58	50.52	50.53	1028750.0
2010-04-26 09:30:00	QQQ	ETF	50.53	50.65	50.4	50.41	12209042.0
2010-04-26 10:00:00	QQQ	ETF	50.41	50.53	50.3	50.38	8776157.0
2010-04-26 10:30:00	QQQ	ETF	50.38	50.52	50.32	50.49	5868195.0
2010-04-26 11:00:00	QQQ	ETF	50.48	50.56	50.45	50.47	2389455.0
2010-04-26 11:30:00	QQQ	ETF	50.47	50.5	50.375	50.4	2894855.0
2010-04-26 12:00:00	QQQ	ETF	50.39	50.44	50.34	50.39	2837259.0
2010-04-26 12:30:00	QQQ	ETF	50.38	50.45	50.36	50.45	1847061.0
2010-04-26 13:00:00	QQQ	ETF	50.45	50.47	50.41	50.41	1199262.0

> showing 50 of 8,552 rows — these rows as CSV

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