PREVIEW / etf_30min / 2010-07-21

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-07-21.parquet
  size:    248 KB
  rows:    8,124

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-21 04:00:00	SPY	ETF	108.68	108.68	108.68	108.68	570.0
2010-07-21 04:30:00	SPY	ETF	108.84	108.87	108.8	108.8	2680.0
2010-07-21 05:30:00	SPY	ETF	108.98	108.98	108.83	108.83	1700.0
2010-07-21 06:00:00	SPY	ETF	108.95	108.95	108.68	108.68	7658.0
2010-07-21 06:30:00	SPY	ETF	108.77	108.77	108.7	108.73	4500.0
2010-07-21 07:00:00	SPY	ETF	108.81	108.88	108.71	108.8	173612.0
2010-07-21 07:30:00	SPY	ETF	108.81	108.92	108.71	108.81	1035626.0
2010-07-21 08:00:00	SPY	ETF	108.8	109.07	108.78	108.99	3242850.0
2010-07-21 08:30:00	SPY	ETF	109.0	109.28	108.7166	109.25	1329589.0
2010-07-21 09:00:00	SPY	ETF	109.26	109.26	109.03	109.03	1518536.0
2010-07-21 09:30:00	SPY	ETF	109.04	109.07	108.23	108.44	26152155.0
2010-07-21 10:00:00	SPY	ETF	108.44	108.68	108.2	108.65	14890251.0
2010-07-21 10:30:00	SPY	ETF	108.65	108.7	108.32	108.43	10897095.0
2010-07-21 11:00:00	SPY	ETF	108.43	108.4601	107.96	108.16	17840240.0
2010-07-21 11:30:00	SPY	ETF	108.17	108.39	108.02	108.38	8870407.0
2010-07-21 12:00:00	SPY	ETF	108.38	108.58	108.3	108.5	10930656.0
2010-07-21 12:30:00	SPY	ETF	108.5	108.8	108.28	108.33	7217259.0
2010-07-21 13:00:00	SPY	ETF	108.32	108.49	108.29	108.44	3644619.0
2010-07-21 13:30:00	SPY	ETF	108.435	108.68	108.33	108.45	5026782.0
2010-07-21 14:00:00	SPY	ETF	108.45	108.53	107.23	107.37	35898410.0
2010-07-21 14:30:00	SPY	ETF	107.37	107.4	106.63	106.77	34498512.0
2010-07-21 15:00:00	SPY	ETF	106.76	107.3	106.66	106.94	26626930.0
2010-07-21 15:30:00	SPY	ETF	106.94	107.4	106.79	107.1	35175915.0
2010-07-21 16:00:00	SPY	ETF	107.09	108.935	106.82	106.83	5951465.0
2010-07-21 16:30:00	SPY	ETF	106.84	108.5094	106.78	106.8	6400938.0
2010-07-21 17:00:00	SPY	ETF	106.82	106.94	106.77	106.82	241622.0
2010-07-21 17:30:00	SPY	ETF	106.8	106.86	106.79	106.8	28690.0
2010-07-21 18:00:00	SPY	ETF	106.82	107.07	106.78	106.96	57991.0
2010-07-21 18:30:00	SPY	ETF	106.94	106.97	106.9	106.92	51131.0
2010-07-21 19:00:00	SPY	ETF	106.95	107.01	106.93	106.99	14464.0
2010-07-21 19:30:00	SPY	ETF	106.98	107.03	106.93	107.02	64320.0
2010-07-21 04:00:00	QQQ	ETF	45.3	45.3	45.3	45.3	100.0
2010-07-21 04:30:00	QQQ	ETF	45.45	45.51	45.45	45.49	1100.0
2010-07-21 05:00:00	QQQ	ETF	45.54	45.54	45.54	45.54	100.0
2010-07-21 06:00:00	QQQ	ETF	45.52	45.52	45.52	45.52	3000.0
2010-07-21 06:30:00	QQQ	ETF	45.48	45.48	45.48	45.48	3500.0
2010-07-21 07:00:00	QQQ	ETF	45.56	45.56	45.5	45.54	154172.0
2010-07-21 07:30:00	QQQ	ETF	45.54	45.58	45.5	45.57	100009.0
2010-07-21 08:00:00	QQQ	ETF	45.56	45.65	45.56	45.62	348699.0
2010-07-21 08:30:00	QQQ	ETF	45.64	45.73	45.63	45.72	429961.0
2010-07-21 09:00:00	QQQ	ETF	45.72	45.75	45.66	45.74	939154.0
2010-07-21 09:30:00	QQQ	ETF	45.75	45.76	45.02	45.16	17648051.0
2010-07-21 10:00:00	QQQ	ETF	45.16	45.26	45.0	45.25	6840367.0
2010-07-21 10:30:00	QQQ	ETF	45.24	45.27	45.09	45.16	4120276.0
2010-07-21 11:00:00	QQQ	ETF	45.17	45.19	44.96	45.06	5643112.0
2010-07-21 11:30:00	QQQ	ETF	45.06	45.22	44.9996	45.22	2794116.0
2010-07-21 12:00:00	QQQ	ETF	45.21	45.33	45.2	45.3	2929117.0
2010-07-21 12:30:00	QQQ	ETF	45.29	45.38	45.22	45.25	2506711.0
2010-07-21 13:00:00	QQQ	ETF	45.24	45.34	45.2299	45.3199	1354721.0
2010-07-21 13:30:00	QQQ	ETF	45.31	45.43	45.27	45.31	2385948.0

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

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