PREVIEW / etf_30min / 2010-12-23

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-12-23.parquet
  size:    251 KB
  rows:    8,547

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-12-23 04:30:00	SPY	ETF	125.71	125.71	125.71	125.71	100.0
2010-12-23 07:00:00	SPY	ETF	125.73	125.76	125.7	125.76	15346.0
2010-12-23 07:30:00	SPY	ETF	125.78	125.78	125.67	125.7	81250.0
2010-12-23 08:00:00	SPY	ETF	125.71	125.73	125.52	125.6	512545.0
2010-12-23 08:30:00	SPY	ETF	125.6	125.69	125.54	125.65	406077.0
2010-12-23 09:00:00	SPY	ETF	125.65	125.68	125.6	125.63	199681.0
2010-12-23 09:30:00	SPY	ETF	125.64	125.78	125.59	125.72	8424793.0
2010-12-23 10:00:00	SPY	ETF	125.72	125.76	125.49	125.59	8501999.0
2010-12-23 10:30:00	SPY	ETF	125.59	125.64	125.53	125.59	4468930.0
2010-12-23 11:00:00	SPY	ETF	125.595	125.71	125.59	125.7	3885973.0
2010-12-23 11:30:00	SPY	ETF	125.7	125.72	125.56	125.6	5213977.0
2010-12-23 12:00:00	SPY	ETF	125.61	125.62	125.52	125.6	2127308.0
2010-12-23 12:30:00	SPY	ETF	125.5942	125.64	125.52	125.56	2562181.0
2010-12-23 13:00:00	SPY	ETF	125.56	125.65	125.55	125.59	2934640.0
2010-12-23 13:30:00	SPY	ETF	125.59	125.61	125.53	125.53	1756489.0
2010-12-23 14:00:00	SPY	ETF	125.53	125.57	125.29	125.34	6380496.0
2010-12-23 14:30:00	SPY	ETF	125.35	125.47	125.33	125.46	4316440.0
2010-12-23 15:00:00	SPY	ETF	125.47	125.57	125.42	125.57	4107879.0
2010-12-23 15:30:00	SPY	ETF	125.56	125.61	125.44	125.59	7632510.0
2010-12-23 16:00:00	SPY	ETF	125.59	125.765	125.325	125.69	3988524.0
2010-12-23 16:30:00	SPY	ETF	125.69	125.71	125.65	125.67	210935.0
2010-12-23 17:00:00	SPY	ETF	125.67	125.68	125.62	125.62	32000.0
2010-12-23 17:30:00	SPY	ETF	125.65	125.67	125.63	125.66	2110.0
2010-12-23 18:00:00	SPY	ETF	125.64	125.65	125.64	125.64	2400.0
2010-12-23 18:30:00	SPY	ETF	125.66	125.66	125.63	125.66	15225.0
2010-12-23 19:00:00	SPY	ETF	125.66	125.66	125.62	125.64	4600.0
2010-12-23 19:30:00	SPY	ETF	125.62	125.66	125.61	125.65	4893.0
2010-12-23 04:00:00	QQQ	ETF	54.9	54.9	54.9	54.9	200.0
2010-12-23 05:30:00	QQQ	ETF	54.92	54.92	54.92	54.92	200.0
2010-12-23 07:00:00	QQQ	ETF	54.81	54.85	54.81	54.85	16375.0
2010-12-23 07:30:00	QQQ	ETF	54.85	54.85	54.82	54.83	4300.0
2010-12-23 08:00:00	QQQ	ETF	54.82	54.83	54.72	54.75	172832.0
2010-12-23 08:30:00	QQQ	ETF	54.75	54.84	54.73	54.79	201158.0
2010-12-23 09:00:00	QQQ	ETF	54.79	54.8	54.76	54.78	69007.0
2010-12-23 09:30:00	QQQ	ETF	54.78	54.87	54.75	54.8	2859238.0
2010-12-23 10:00:00	QQQ	ETF	54.8	54.84	54.61	54.6636	2625909.0
2010-12-23 10:30:00	QQQ	ETF	54.67	54.7095	54.64	54.67	1407862.0
2010-12-23 11:00:00	QQQ	ETF	54.67	54.75	54.67	54.745	1994568.0
2010-12-23 11:30:00	QQQ	ETF	54.75	54.76	54.68	54.709	1554694.0
2010-12-23 12:00:00	QQQ	ETF	54.7	54.701	54.6425	54.6901	852697.0
2010-12-23 12:30:00	QQQ	ETF	54.6936	54.73	54.6748	54.705	850048.0
2010-12-23 13:00:00	QQQ	ETF	54.7095	54.76	54.7095	54.72	861573.0
2010-12-23 13:30:00	QQQ	ETF	54.7236	54.74	54.71	54.71	764219.0
2010-12-23 14:00:00	QQQ	ETF	54.7022	54.72	54.64	54.66	1617244.0
2010-12-23 14:30:00	QQQ	ETF	54.669	54.7	54.66	54.69	807823.0
2010-12-23 15:00:00	QQQ	ETF	54.6899	54.76	54.67	54.75	1407986.0
2010-12-23 15:30:00	QQQ	ETF	54.75	54.76	54.69	54.75	2503728.0
2010-12-23 16:00:00	QQQ	ETF	54.74	54.83	54.74	54.76	561877.0
2010-12-23 16:30:00	QQQ	ETF	54.76	54.76	54.745	54.745	1700.0
2010-12-23 17:00:00	QQQ	ETF	54.77	54.78	54.76	54.78	14660.0

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

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