PREVIEW / etf_30min / 2010-04-08

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-04-08.parquet
  size:    250 KB
  rows:    8,296

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-08 04:00:00	SPY	ETF	117.89	117.89	117.77	117.77	2200.0
2010-04-08 04:30:00	SPY	ETF	117.78	117.9	117.78	117.9	3200.0
2010-04-08 05:00:00	SPY	ETF	117.85	117.85	117.85	117.85	2500.0
2010-04-08 05:30:00	SPY	ETF	117.89	117.9	117.8	117.9	5550.0
2010-04-08 06:00:00	SPY	ETF	117.87	118.02	117.85	118.02	8700.0
2010-04-08 06:30:00	SPY	ETF	117.99	118.02	117.97	118.0	4900.0
2010-04-08 07:00:00	SPY	ETF	118.01	118.04	117.86	117.9	382315.0
2010-04-08 07:30:00	SPY	ETF	117.88	117.9	117.74	117.78	292919.0
2010-04-08 08:00:00	SPY	ETF	117.78	118.0	117.77	117.9	1631944.0
2010-04-08 08:30:00	SPY	ETF	117.89	117.97	117.69	117.97	1804090.0
2010-04-08 09:00:00	SPY	ETF	117.98	118.02	117.81	117.95	1238643.0
2010-04-08 09:30:00	SPY	ETF	117.95	117.97	117.6	117.7299	24337916.0
2010-04-08 10:00:00	SPY	ETF	117.72	118.02	117.64	117.99	13801937.0
2010-04-08 10:30:00	SPY	ETF	117.99	118.1117	117.94	118.01	8515216.0
2010-04-08 11:00:00	SPY	ETF	118.005	118.2	117.99	117.99	7490736.0
2010-04-08 11:30:00	SPY	ETF	118.0	118.34	117.99	118.33	9432608.0
2010-04-08 12:00:00	SPY	ETF	118.32	118.55	118.27	118.5	12541957.0
2010-04-08 12:30:00	SPY	ETF	118.5	118.66	118.45	118.648	6560191.0
2010-04-08 13:00:00	SPY	ETF	118.645	118.77	118.6	118.6682	9203030.0
2010-04-08 13:30:00	SPY	ETF	118.67	118.82	118.6	118.655	9673673.0
2010-04-08 14:00:00	SPY	ETF	118.65	118.83	118.63	118.8004	5245337.0
2010-04-08 14:30:00	SPY	ETF	118.805	118.97	118.2	118.885	7416495.0
2010-04-08 15:00:00	SPY	ETF	118.89	118.95	118.78	118.865	6474053.0
2010-04-08 15:30:00	SPY	ETF	118.865	118.97	118.74	118.76	16564814.0
2010-04-08 16:00:00	SPY	ETF	118.76	118.92	117.65	118.83	9309975.0
2010-04-08 16:30:00	SPY	ETF	118.84	118.89	117.82	118.89	2915056.0
2010-04-08 17:00:00	SPY	ETF	118.3527	118.89	118.3527	118.86	1551892.0
2010-04-08 17:30:00	SPY	ETF	118.89	118.91	118.84	118.85	61783.0
2010-04-08 18:00:00	SPY	ETF	118.87	118.92	118.83	118.89	105374.0
2010-04-08 18:30:00	SPY	ETF	118.88	118.92	118.88	118.88	25745.0
2010-04-08 19:00:00	SPY	ETF	118.88	118.92	118.88	118.89	15300.0
2010-04-08 19:30:00	SPY	ETF	118.9	118.92	118.89	118.92	61700.0
2010-04-08 07:00:00	QQQ	ETF	48.53	48.54	48.5	48.5	3201.0
2010-04-08 07:30:00	QQQ	ETF	48.5	48.5	48.46	48.47	18866.0
2010-04-08 08:00:00	QQQ	ETF	48.48	48.56	48.41	48.53	159961.0
2010-04-08 08:30:00	QQQ	ETF	48.51	48.53	48.44	48.51	239436.0
2010-04-08 09:00:00	QQQ	ETF	48.52	48.54	48.45	48.5	580312.0
2010-04-08 09:30:00	QQQ	ETF	48.5	48.51	48.24	48.29	10487313.0
2010-04-08 10:00:00	QQQ	ETF	48.29	48.44	48.2601	48.43	7023641.0
2010-04-08 10:30:00	QQQ	ETF	48.43	48.51	48.41	48.43	4948274.0
2010-04-08 11:00:00	QQQ	ETF	48.42	48.51	48.326	48.42	3008619.0
2010-04-08 11:30:00	QQQ	ETF	48.41	48.575	48.41	48.55	2847656.0
2010-04-08 12:00:00	QQQ	ETF	48.56	48.71	48.53	48.7	4209632.0
2010-04-08 12:30:00	QQQ	ETF	48.7	48.78	48.66	48.77	2791756.0
2010-04-08 13:00:00	QQQ	ETF	48.77	48.82	48.69	48.7318	5319643.0
2010-04-08 13:30:00	QQQ	ETF	48.7324	48.785	48.67	48.691	3123268.0
2010-04-08 14:00:00	QQQ	ETF	48.69	48.8143	48.67	48.75	2523007.0
2010-04-08 14:30:00	QQQ	ETF	48.75	48.81	48.71	48.775	3191465.0
2010-04-08 15:00:00	QQQ	ETF	48.77	48.79	48.71	48.765	2849121.0
2010-04-08 15:30:00	QQQ	ETF	48.7699	48.8	48.69	48.71	5492225.0

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

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