PREVIEW / etf_30min / 2010-06-30

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-06-30.parquet
  size:    257 KB
  rows:    8,609

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-06-30 04:00:00	SPY	ETF	104.65	104.66	104.63	104.66	6406.0
2010-06-30 04:30:00	SPY	ETF	104.55	104.59	104.42	104.47	41900.0
2010-06-30 05:00:00	SPY	ETF	104.55	104.84	104.29	104.84	24100.0
2010-06-30 05:30:00	SPY	ETF	104.68	104.88	104.65	104.88	15310.0
2010-06-30 06:00:00	SPY	ETF	104.89	104.92	104.76	104.76	5597.0
2010-06-30 06:30:00	SPY	ETF	104.68	104.87	104.63	104.78	363400.0
2010-06-30 07:00:00	SPY	ETF	104.77	104.8	104.68	104.72	335050.0
2010-06-30 07:30:00	SPY	ETF	104.74	104.77	104.63	104.64	425243.0
2010-06-30 08:00:00	SPY	ETF	104.65	104.72	103.9	104.13	2786839.0
2010-06-30 08:30:00	SPY	ETF	104.13	104.33	104.03	104.03	2302346.0
2010-06-30 09:00:00	SPY	ETF	104.04	104.6	103.85	103.92	2272720.0
2010-06-30 09:30:00	SPY	ETF	103.92	104.76	103.85	104.43	30520783.0
2010-06-30 10:00:00	SPY	ETF	104.44	104.56	104.22	104.34	22629219.0
2010-06-30 10:30:00	SPY	ETF	104.34	104.67	104.15	104.21	19287902.0
2010-06-30 11:00:00	SPY	ETF	104.21	104.72	104.16	104.53	13763648.0
2010-06-30 11:30:00	SPY	ETF	104.53	104.88	104.42	104.7	11158585.0
2010-06-30 12:00:00	SPY	ETF	104.7	104.79	104.61	104.63	8711694.0
2010-06-30 12:30:00	SPY	ETF	104.64	104.7	104.35	104.5	9158409.0
2010-06-30 13:00:00	SPY	ETF	104.5	104.64	104.375	104.58	6244431.0
2010-06-30 13:30:00	SPY	ETF	104.59	104.65	104.35	104.56	8730335.0
2010-06-30 14:00:00	SPY	ETF	104.55	104.69	104.07	104.19	18124844.0
2010-06-30 14:30:00	SPY	ETF	104.19	104.42	104.07	104.25	13799207.0
2010-06-30 15:00:00	SPY	ETF	104.25	104.36	103.75	103.7826	16152313.0
2010-06-30 15:30:00	SPY	ETF	103.7899	103.82	102.88	103.11	63354497.0
2010-06-30 16:00:00	SPY	ETF	103.1	104.87	102.84	102.97	18084635.0
2010-06-30 16:30:00	SPY	ETF	102.98	103.141	102.92	103.02	10553891.0
2010-06-30 17:00:00	SPY	ETF	103.02	103.03	102.89	102.93	1301865.0
2010-06-30 17:30:00	SPY	ETF	102.91	102.98	102.85	102.9	150283.0
2010-06-30 18:00:00	SPY	ETF	102.9	102.96	102.82	102.88	313977.0
2010-06-30 18:30:00	SPY	ETF	102.88	102.93	102.84	102.87	49825.0
2010-06-30 19:00:00	SPY	ETF	102.88	103.0	102.88	103.0	69949.0
2010-06-30 19:30:00	SPY	ETF	102.99	103.14	102.98	103.13	390200.0
2010-06-30 04:00:00	QQQ	ETF	43.63	43.63	43.57	43.59	2200.0
2010-06-30 05:00:00	QQQ	ETF	43.58	43.67	43.5	43.67	1200.0
2010-06-30 05:30:00	QQQ	ETF	43.71	43.71	43.67	43.67	300.0
2010-06-30 06:00:00	QQQ	ETF	43.7	43.7	43.63	43.63	18900.0
2010-06-30 06:30:00	QQQ	ETF	43.64	43.64	43.63	43.63	200.0
2010-06-30 07:00:00	QQQ	ETF	43.64	43.67	43.6	43.61	110125.0
2010-06-30 07:30:00	QQQ	ETF	43.62	43.65	43.61	43.63	40935.0
2010-06-30 08:00:00	QQQ	ETF	43.61	43.63	43.33	43.42	812445.0
2010-06-30 08:30:00	QQQ	ETF	43.44	43.48	43.38	43.39	249240.0
2010-06-30 09:00:00	QQQ	ETF	43.38	43.41	43.25	43.27	756847.0
2010-06-30 09:30:00	QQQ	ETF	43.26	43.64	43.22	43.48	12714863.0
2010-06-30 10:00:00	QQQ	ETF	43.48	43.62	43.4	43.44	5128060.0
2010-06-30 10:30:00	QQQ	ETF	43.44	43.58	43.34	43.36	5747606.0
2010-06-30 11:00:00	QQQ	ETF	43.36	43.6	43.34	43.53	4036564.0
2010-06-30 11:30:00	QQQ	ETF	43.53	43.67	43.52	43.59	3341296.0
2010-06-30 12:00:00	QQQ	ETF	43.585	43.67	43.56	43.61	1557665.0
2010-06-30 12:30:00	QQQ	ETF	43.61	43.65	43.45	43.5301	3578307.0
2010-06-30 13:00:00	QQQ	ETF	43.54	43.58	43.44	43.5299	3297454.0

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

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