PREVIEW / etf_30min / 2010-09-23

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-09-23.parquet
  size:    260 KB
  rows:    8,651

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-09-23 04:00:00	SPY	ETF	113.4	113.4	113.4	113.4	100.0
2010-09-23 04:30:00	SPY	ETF	113.29	113.3	112.76	112.76	7250.0
2010-09-23 05:00:00	SPY	ETF	112.83	112.85	112.74	112.85	2700.0
2010-09-23 05:30:00	SPY	ETF	112.77	112.77	112.77	112.77	100.0
2010-09-23 06:00:00	SPY	ETF	112.86	112.89	112.8	112.86	11950.0
2010-09-23 06:30:00	SPY	ETF	112.83	112.96	112.65	112.74	137000.0
2010-09-23 07:00:00	SPY	ETF	112.71	112.79	112.61	112.64	289090.0
2010-09-23 07:30:00	SPY	ETF	112.63	112.76	112.55	112.66	164895.0
2010-09-23 08:00:00	SPY	ETF	112.92	112.92	112.5	112.69	1729294.0
2010-09-23 08:30:00	SPY	ETF	112.69	112.7	112.22	112.36	3732702.0
2010-09-23 09:00:00	SPY	ETF	112.34	113.43	112.33	112.48	962161.0
2010-09-23 09:30:00	SPY	ETF	112.49	112.75	112.27	112.54	24273594.0
2010-09-23 10:00:00	SPY	ETF	112.55	113.11	112.522	113.1	24114436.0
2010-09-23 10:30:00	SPY	ETF	113.0901	113.43	113.07	113.19	22453335.0
2010-09-23 11:00:00	SPY	ETF	113.18	113.42	113.1079	113.42	10578806.0
2010-09-23 11:30:00	SPY	ETF	113.41	113.67	113.2	113.4593	12629645.0
2010-09-23 12:00:00	SPY	ETF	113.45	113.52	113.31	113.34	5688506.0
2010-09-23 12:30:00	SPY	ETF	113.34	113.42	113.25	113.35	5786670.0
2010-09-23 13:00:00	SPY	ETF	113.34	113.43	113.22	113.32	3472178.0
2010-09-23 13:30:00	SPY	ETF	113.32	113.4	113.14	113.21	6086579.0
2010-09-23 14:00:00	SPY	ETF	113.215	113.38	113.21	113.27	5080763.0
2010-09-23 14:30:00	SPY	ETF	113.28	113.34	112.78	112.825	12530255.0
2010-09-23 15:00:00	SPY	ETF	112.83	112.91	112.42	112.44	20367240.0
2010-09-23 15:30:00	SPY	ETF	112.43	112.53	112.18	112.49	30373635.0
2010-09-23 16:00:00	SPY	ETF	112.49	113.615	112.315	112.5	8599831.0
2010-09-23 16:30:00	SPY	ETF	112.52	112.55	112.41	112.46	1123868.0
2010-09-23 17:00:00	SPY	ETF	112.46	112.52	112.44	112.5	62655.0
2010-09-23 17:30:00	SPY	ETF	112.5	112.52	112.47	112.52	19040.0
2010-09-23 18:00:00	SPY	ETF	112.5	112.57	112.38	112.4	65030.0
2010-09-23 18:30:00	SPY	ETF	112.41	112.43	112.41	112.43	35385.0
2010-09-23 19:00:00	SPY	ETF	112.42	112.43	112.39	112.41	15683.0
2010-09-23 19:30:00	SPY	ETF	112.4	112.42	112.33	112.33	118938.0
2010-09-23 04:00:00	QQQ	ETF	48.78	48.78	48.7	48.7	600.0
2010-09-23 04:30:00	QQQ	ETF	48.5	48.5	48.5	48.5	1500.0
2010-09-23 05:30:00	QQQ	ETF	48.53	48.53	48.49	48.49	200.0
2010-09-23 06:00:00	QQQ	ETF	48.56	48.56	48.52	48.52	1550.0
2010-09-23 06:30:00	QQQ	ETF	48.51	48.55	48.46	48.48	700.0
2010-09-23 07:00:00	QQQ	ETF	48.48	48.49	48.41	48.44	79456.0
2010-09-23 07:30:00	QQQ	ETF	48.43	48.45	48.38	48.43	260449.0
2010-09-23 08:00:00	QQQ	ETF	48.43	48.5	48.34	48.41	632056.0
2010-09-23 08:30:00	QQQ	ETF	48.36	48.37	48.24	48.31	791130.0
2010-09-23 09:00:00	QQQ	ETF	48.3	48.39	48.28	48.38	393676.0
2010-09-23 09:30:00	QQQ	ETF	48.39	48.65	48.32	48.59	9610175.0
2010-09-23 10:00:00	QQQ	ETF	48.58	48.85	48.58	48.85	8130520.0
2010-09-23 10:30:00	QQQ	ETF	48.85	48.99	48.83	48.9	7465502.0
2010-09-23 11:00:00	QQQ	ETF	48.89	49.11	48.86	49.105	5714715.0
2010-09-23 11:30:00	QQQ	ETF	49.1	49.16	49.03	49.0747	4832531.0
2010-09-23 12:00:00	QQQ	ETF	49.07	49.12	49.02	49.05	2229466.0
2010-09-23 12:30:00	QQQ	ETF	49.05	49.1	49.0	49.02	1767548.0
2010-09-23 13:00:00	QQQ	ETF	49.03	49.09	49.0	49.04	1686815.0

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

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