PREVIEW / etf_30min / 2010-11-26

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-11-26.parquet
  size:    162 KB
  rows:    5,163

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-11-26 04:00:00	SPY	ETF	119.95	119.95	119.63	119.65	25900.0
2010-11-26 04:30:00	SPY	ETF	119.61	119.61	119.1	119.19	52500.0
2010-11-26 05:00:00	SPY	ETF	119.21	119.33	119.0	119.33	15200.0
2010-11-26 05:30:00	SPY	ETF	119.26	119.34	119.04	119.11	600.0
2010-11-26 06:00:00	SPY	ETF	119.11	119.11	118.87	118.98	24750.0
2010-11-26 06:30:00	SPY	ETF	119.1	119.1	118.79	119.07	296050.0
2010-11-26 07:00:00	SPY	ETF	119.07	119.08	118.78	118.89	568388.0
2010-11-26 07:30:00	SPY	ETF	118.9	119.26	118.9	119.2	907100.0
2010-11-26 08:00:00	SPY	ETF	119.23	119.28	118.62	119.04	1685717.0
2010-11-26 08:30:00	SPY	ETF	119.04	119.23	118.96	119.22	1056187.0
2010-11-26 09:00:00	SPY	ETF	119.21	119.42	119.16	119.17	1371531.0
2010-11-26 09:30:00	SPY	ETF	119.16	119.61	119.03	119.6	14490999.0
2010-11-26 10:00:00	SPY	ETF	119.59	119.81	119.46	119.65	8049658.0
2010-11-26 10:30:00	SPY	ETF	119.66	119.75	119.41	119.42	6009710.0
2010-11-26 11:00:00	SPY	ETF	119.42	119.54	119.37	119.425	6357393.0
2010-11-26 11:30:00	SPY	ETF	119.42	119.455	119.21	119.41	11007381.0
2010-11-26 12:00:00	SPY	ETF	119.41	119.5	119.24	119.44	3841132.0
2010-11-26 12:30:00	SPY	ETF	119.45	119.54	119.29	119.3	8171019.0
2010-11-26 13:00:00	SPY	ETF	119.3	119.302	118.82	118.94	4660607.0
2010-11-26 13:30:00	SPY	ETF	118.93	118.97	118.78	118.8	644302.0
2010-11-26 14:00:00	SPY	ETF	118.79	118.85	118.68	118.78	284388.0
2010-11-26 14:30:00	SPY	ETF	118.78	118.86	118.75	118.78	180555.0
2010-11-26 15:00:00	SPY	ETF	118.76	118.84	118.76	118.81	55181.0
2010-11-26 15:30:00	SPY	ETF	118.8	118.84	118.74	118.74	171662.0
2010-11-26 16:00:00	SPY	ETF	118.72	118.78	118.72	118.76	6025.0
2010-11-26 16:30:00	SPY	ETF	118.78	118.84	118.75	118.84	14780.0
2010-11-26 04:00:00	QQQ	ETF	52.95	52.95	52.79	52.79	5300.0
2010-11-26 05:00:00	QQQ	ETF	52.67	52.67	52.61	52.61	1000.0
2010-11-26 05:30:00	QQQ	ETF	52.65	52.65	52.65	52.65	500.0
2010-11-26 06:30:00	QQQ	ETF	52.58	52.61	52.55	52.61	1400.0
2010-11-26 07:00:00	QQQ	ETF	52.6	52.61	52.54	52.57	103400.0
2010-11-26 07:30:00	QQQ	ETF	52.57	52.68	52.57	52.66	56181.0
2010-11-26 08:00:00	QQQ	ETF	52.68	52.71	52.58	52.62	289114.0
2010-11-26 08:30:00	QQQ	ETF	52.62	52.72	52.58	52.72	317667.0
2010-11-26 09:00:00	QQQ	ETF	52.71	52.9	52.7	52.79	912921.0
2010-11-26 09:30:00	QQQ	ETF	52.79	53.03	52.67	53.0	7293437.0
2010-11-26 10:00:00	QQQ	ETF	52.995	53.13	52.93	53.07	3164719.0
2010-11-26 10:30:00	QQQ	ETF	53.08	53.13	52.92	52.948	1560914.0
2010-11-26 11:00:00	QQQ	ETF	52.94	53.06	52.9201	52.99	1195663.0
2010-11-26 11:30:00	QQQ	ETF	53.0	53.0175	52.92	53.015	825877.0
2010-11-26 12:00:00	QQQ	ETF	53.01	53.05	52.93	53.01	775477.0
2010-11-26 12:30:00	QQQ	ETF	53.01	53.03	52.97	52.97	3402479.0
2010-11-26 13:00:00	QQQ	ETF	52.97	52.97	52.75	52.8	2092798.0
2010-11-26 13:30:00	QQQ	ETF	52.79	53.0201	52.75	52.76	53021.0
2010-11-26 14:00:00	QQQ	ETF	52.76	52.76	52.73	52.75	19110.0
2010-11-26 14:30:00	QQQ	ETF	52.73	52.76	52.73	52.76	23259.0
2010-11-26 15:00:00	QQQ	ETF	52.76	52.76	52.74	52.74	23800.0
2010-11-26 15:30:00	QQQ	ETF	52.76	52.76	52.75	52.75	3300.0
2010-11-26 16:00:00	QQQ	ETF	52.74	52.75	52.73	52.75	2100.0
2010-11-26 16:30:00	QQQ	ETF	52.75	52.75	52.74	52.75	21513.0

> showing 50 of 5,163 rows — these rows as CSV

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