PREVIEW / etf_30min / 2009-05-26

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-05-26.parquet
  size:    217 KB
  rows:    7,314

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
2009-05-26 04:00:00	SPY	ETF	88.69	88.69	88.61	88.61	750.0
2009-05-26 04:30:00	SPY	ETF	88.78	88.78	88.66	88.66	400.0
2009-05-26 05:00:00	SPY	ETF	88.61	88.62	88.49	88.62	2092.0
2009-05-26 05:30:00	SPY	ETF	88.68	88.68	88.68	88.68	200.0
2009-05-26 06:00:00	SPY	ETF	88.7	88.7	88.46	88.52	6473.0
2009-05-26 06:30:00	SPY	ETF	88.37	88.39	88.2	88.39	59800.0
2009-05-26 07:00:00	SPY	ETF	88.35	88.55	88.23	88.53	486722.0
2009-05-26 07:30:00	SPY	ETF	88.55	88.73	88.52	88.59	618504.0
2009-05-26 08:00:00	SPY	ETF	88.4	89.15	88.4	88.76	1865494.0
2009-05-26 08:30:00	SPY	ETF	88.76	88.85	88.65	88.7	2545198.0
2009-05-26 09:00:00	SPY	ETF	88.69	89.0	88.31	88.36	1555380.0
2009-05-26 09:30:00	SPY	ETF	88.36	89.39	88.32	89.39	23925707.0
2009-05-26 10:00:00	SPY	ETF	89.37	90.7	89.28	90.45	46998214.0
2009-05-26 10:30:00	SPY	ETF	90.46	90.88	90.45	90.7018	18693236.0
2009-05-26 11:00:00	SPY	ETF	90.71	90.85	90.58	90.77	10581614.0
2009-05-26 11:30:00	SPY	ETF	90.78	91.0	90.71	90.89	9620374.0
2009-05-26 12:00:00	SPY	ETF	90.89	91.04	90.75	91.01	7655402.0
2009-05-26 12:30:00	SPY	ETF	91.01	91.38	90.89	91.26	10312335.0
2009-05-26 13:00:00	SPY	ETF	91.27	91.42	91.14	91.28	9137923.0
2009-05-26 13:30:00	SPY	ETF	91.28	91.41	91.13	91.372	8324659.0
2009-05-26 14:00:00	SPY	ETF	91.38	91.52	91.23	91.2999	11213293.0
2009-05-26 14:30:00	SPY	ETF	91.29	91.56	91.11	91.1199	13598380.0
2009-05-26 15:00:00	SPY	ETF	91.12	91.35	90.93	91.07	15910973.0
2009-05-26 15:30:00	SPY	ETF	91.07	91.4	90.79	91.32	33603546.0
2009-05-26 16:00:00	SPY	ETF	91.32	91.47	88.75	91.23	7253089.0
2009-05-26 16:30:00	SPY	ETF	91.24	91.35	91.2	91.35	277071.0
2009-05-26 17:00:00	SPY	ETF	91.33	91.44	89.0322	91.38	1234273.0
2009-05-26 17:30:00	SPY	ETF	91.31	91.39	91.31	91.35	24815.0
2009-05-26 18:00:00	SPY	ETF	91.35	91.35	91.29	91.3	21376.0
2009-05-26 18:30:00	SPY	ETF	91.3	91.33	91.28	91.32	8332.0
2009-05-26 19:00:00	SPY	ETF	91.3	91.43	91.3	91.42	68550.0
2009-05-26 19:30:00	SPY	ETF	91.42	91.43	91.31	91.31	49752.0
2009-05-26 04:00:00	QQQ	ETF	33.28	33.28	33.25	33.25	400.0
2009-05-26 05:00:00	QQQ	ETF	33.23	33.23	33.23	33.23	200.0
2009-05-26 06:00:00	QQQ	ETF	33.21	33.21	33.18	33.18	651.0
2009-05-26 06:30:00	QQQ	ETF	33.16	33.16	33.1	33.1	1400.0
2009-05-26 07:00:00	QQQ	ETF	33.1	33.23	33.1	33.23	271823.0
2009-05-26 07:30:00	QQQ	ETF	33.25	33.31	33.23	33.31	501057.0
2009-05-26 08:00:00	QQQ	ETF	33.3	33.47	33.2	33.4	1602866.0
2009-05-26 08:30:00	QQQ	ETF	33.41	33.44	33.38	33.4	1267506.0
2009-05-26 09:00:00	QQQ	ETF	33.38	33.38	33.19	33.2	1156194.0
2009-05-26 09:30:00	QQQ	ETF	33.19	33.98	33.18	33.97	21142484.0
2009-05-26 10:00:00	QQQ	ETF	33.97	34.57	33.97	34.43	29162260.0
2009-05-26 10:30:00	QQQ	ETF	34.43	34.62	34.43	34.53	10466254.0
2009-05-26 11:00:00	QQQ	ETF	34.53	34.61	34.47	34.58	5930461.0
2009-05-26 11:30:00	QQQ	ETF	34.58	34.7	34.53	34.66	5198677.0
2009-05-26 12:00:00	QQQ	ETF	34.66	34.69	34.59	34.68	3573065.0
2009-05-26 12:30:00	QQQ	ETF	34.6702	34.76	34.625	34.712	3387855.0
2009-05-26 13:00:00	QQQ	ETF	34.71	34.77	34.68	34.77	4993791.0
2009-05-26 13:30:00	QQQ	ETF	34.76	34.82	34.69	34.8	3342933.0

> showing 50 of 7,314 rows — these rows as CSV

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