PREVIEW / etf_30min / 2010-07-02

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-07-02.parquet
  size:    251 KB
  rows:    8,260

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-07-02 04:00:00	SPY	ETF	102.82	102.82	102.82	102.82	100.0
2010-07-02 05:30:00	SPY	ETF	102.71	102.8	102.64	102.8	3000.0
2010-07-02 06:00:00	SPY	ETF	102.8	102.88	102.8	102.8	19900.0
2010-07-02 06:30:00	SPY	ETF	102.79	102.79	102.67	102.67	5400.0
2010-07-02 07:00:00	SPY	ETF	102.67	102.87	102.66	102.87	155227.0
2010-07-02 07:30:00	SPY	ETF	102.84	103.03	102.84	103.02	523350.0
2010-07-02 08:00:00	SPY	ETF	103.0	103.48	102.71	103.48	3479728.0
2010-07-02 08:30:00	SPY	ETF	103.41	103.75	102.27	102.67	17904271.0
2010-07-02 09:00:00	SPY	ETF	102.66	103.28	102.62	103.11	4929517.0
2010-07-02 09:30:00	SPY	ETF	103.11	103.42	102.68	102.95	28929804.0
2010-07-02 10:00:00	SPY	ETF	102.95	103.13	102.45	102.88	21123849.0
2010-07-02 10:30:00	SPY	ETF	102.88	102.94	102.54	102.59	11684528.0
2010-07-02 11:00:00	SPY	ETF	102.59	102.74	102.29	102.31	12138957.0
2010-07-02 11:30:00	SPY	ETF	102.3	102.33	101.8	102.1081	15080735.0
2010-07-02 12:00:00	SPY	ETF	102.1001	102.35	101.98	102.17	8812461.0
2010-07-02 12:30:00	SPY	ETF	102.18	102.23	101.85	101.885	5580168.0
2010-07-02 13:00:00	SPY	ETF	101.885	102.07	101.62	101.8017	11869594.0
2010-07-02 13:30:00	SPY	ETF	101.8017	102.26	101.77	102.21	12783038.0
2010-07-02 14:00:00	SPY	ETF	102.22	102.27	101.99	102.09	6544793.0
2010-07-02 14:30:00	SPY	ETF	102.09	102.21	101.91	102.195	10192761.0
2010-07-02 15:00:00	SPY	ETF	102.19	102.66	102.11	102.54	10651409.0
2010-07-02 15:30:00	SPY	ETF	102.54	103.11	102.23	102.26	26259102.0
2010-07-02 16:00:00	SPY	ETF	102.26	103.0486	101.87	101.9862	13353632.0
2010-07-02 16:30:00	SPY	ETF	101.99	102.8149	101.9	101.93	6644969.0
2010-07-02 17:00:00	SPY	ETF	101.95	101.96	101.86	101.91	163556.0
2010-07-02 17:30:00	SPY	ETF	101.88	101.95	101.88	101.94	43744.0
2010-07-02 18:00:00	SPY	ETF	101.95	102.2	101.87	101.91	28798.0
2010-07-02 18:30:00	SPY	ETF	101.91	101.95	101.9	101.94	34048.0
2010-07-02 19:00:00	SPY	ETF	101.92	101.94	101.9	101.92	4136.0
2010-07-02 19:30:00	SPY	ETF	101.9	101.91	101.86	101.9	26478.0
2010-07-02 05:30:00	QQQ	ETF	42.58	42.62	42.58	42.62	3200.0
2010-07-02 06:30:00	QQQ	ETF	42.59	42.59	42.59	42.59	200.0
2010-07-02 07:00:00	QQQ	ETF	42.59	42.63	42.57	42.63	21191.0
2010-07-02 07:30:00	QQQ	ETF	42.63	42.72	42.62	42.71	28750.0
2010-07-02 08:00:00	QQQ	ETF	42.73	42.81	42.56	42.73	383402.0
2010-07-02 08:30:00	QQQ	ETF	42.73	42.95	42.41	42.56	2411073.0
2010-07-02 09:00:00	QQQ	ETF	42.55	42.83	42.54	42.66	2206618.0
2010-07-02 09:30:00	QQQ	ETF	42.67	42.8215	42.53	42.64	11178364.0
2010-07-02 10:00:00	QQQ	ETF	42.64	42.73	42.45	42.62	5848716.0
2010-07-02 10:30:00	QQQ	ETF	42.61	42.65	42.47	42.49	3323534.0
2010-07-02 11:00:00	QQQ	ETF	42.5	42.6	42.42	42.4601	4236487.0
2010-07-02 11:30:00	QQQ	ETF	42.46	42.5	42.25	42.36	5035236.0
2010-07-02 12:00:00	QQQ	ETF	42.37	42.48	42.27	42.37	3771374.0
2010-07-02 12:30:00	QQQ	ETF	42.37	42.41	42.23	42.26	2154042.0
2010-07-02 13:00:00	QQQ	ETF	42.2696	42.3	42.09	42.2	5332876.0
2010-07-02 13:30:00	QQQ	ETF	42.19	42.44	42.1738	42.41	3457007.0
2010-07-02 14:00:00	QQQ	ETF	42.42	42.47	42.32	42.38	3784094.0
2010-07-02 14:30:00	QQQ	ETF	42.38	42.44	42.29	42.4319	2352144.0
2010-07-02 15:00:00	QQQ	ETF	42.43	42.61	42.38	42.56	3780503.0
2010-07-02 15:30:00	QQQ	ETF	42.55	42.81	42.46	42.47	8382580.0

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

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