PREVIEW / etf_30min / 2009-05-22

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-05-22.parquet
  size:    212 KB
  rows:    7,064

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-22 04:00:00	SPY	ETF	89.69	89.84	89.69	89.8	2700.0
2009-05-22 04:30:00	SPY	ETF	89.84	89.99	89.84	89.9	6000.0
2009-05-22 05:00:00	SPY	ETF	89.96	89.96	89.96	89.96	400.0
2009-05-22 05:30:00	SPY	ETF	89.94	90.02	89.94	90.02	4800.0
2009-05-22 06:00:00	SPY	ETF	90.02	90.02	89.97	89.97	2100.0
2009-05-22 06:30:00	SPY	ETF	90.02	90.02	89.9	89.92	51700.0
2009-05-22 07:00:00	SPY	ETF	89.95	89.99	89.77	89.82	137105.0
2009-05-22 07:30:00	SPY	ETF	89.87	89.87	89.62	89.68	465915.0
2009-05-22 08:00:00	SPY	ETF	89.933	89.99	89.61	89.95	1021229.0
2009-05-22 08:30:00	SPY	ETF	89.95	89.95	89.71	89.71	534294.0
2009-05-22 09:00:00	SPY	ETF	89.71	89.73	89.34	89.44	1668380.0
2009-05-22 09:30:00	SPY	ETF	89.46	89.54	88.68	88.98	25163113.0
2009-05-22 10:00:00	SPY	ETF	88.99	89.66	88.85	89.485	20872276.0
2009-05-22 10:30:00	SPY	ETF	89.48	89.84	89.29	89.7194	14933715.0
2009-05-22 11:00:00	SPY	ETF	89.71	89.92	89.58	89.71	9680501.0
2009-05-22 11:30:00	SPY	ETF	89.71	89.76	89.46	89.57	9870869.0
2009-05-22 12:00:00	SPY	ETF	89.56	89.81	89.41	89.43	8668888.0
2009-05-22 12:30:00	SPY	ETF	89.422	89.75	89.37	89.715	6450516.0
2009-05-22 13:00:00	SPY	ETF	89.7001	89.835	89.58	89.66	6442788.0
2009-05-22 13:30:00	SPY	ETF	89.66	89.69	89.35	89.61	10075682.0
2009-05-22 14:00:00	SPY	ETF	89.61	89.73	89.5	89.66	7636346.0
2009-05-22 14:30:00	SPY	ETF	89.67	89.89	89.58	89.87	7503110.0
2009-05-22 15:00:00	SPY	ETF	89.87	90.0	89.43	89.4999	10658711.0
2009-05-22 15:30:00	SPY	ETF	89.4974	89.76	89.01	89.05	16477796.0
2009-05-22 16:00:00	SPY	ETF	89.01	89.35	88.8	88.91	7049443.0
2009-05-22 16:30:00	SPY	ETF	88.92	89.1	88.92	89.03	229443.0
2009-05-22 17:00:00	SPY	ETF	89.02	89.05	88.98	89.0	27872.0
2009-05-22 17:30:00	SPY	ETF	89.0	89.0	88.94	88.96	48150.0
2009-05-22 18:00:00	SPY	ETF	88.96	88.96	88.9	88.94	8700.0
2009-05-22 18:30:00	SPY	ETF	88.95	88.96	88.94	88.94	5526.0
2009-05-22 19:00:00	SPY	ETF	88.95	89.0	88.94	88.99	13728.0
2009-05-22 19:30:00	SPY	ETF	88.97	88.99	88.95	88.97	21150.0
2009-05-22 04:00:00	QQQ	ETF	33.89	33.9	33.87	33.9	400.0
2009-05-22 04:30:00	QQQ	ETF	33.97	33.97	33.93	33.93	1100.0
2009-05-22 05:00:00	QQQ	ETF	33.94	33.98	33.94	33.98	5100.0
2009-05-22 05:30:00	QQQ	ETF	33.93	33.93	33.93	33.93	300.0
2009-05-22 06:00:00	QQQ	ETF	33.95	33.95	33.95	33.95	600.0
2009-05-22 06:30:00	QQQ	ETF	33.96	33.96	33.93	33.93	9500.0
2009-05-22 07:00:00	QQQ	ETF	33.95	33.97	33.88	33.97	171262.0
2009-05-22 07:30:00	QQQ	ETF	33.95	33.95	33.82	33.86	113478.0
2009-05-22 08:00:00	QQQ	ETF	33.83	33.98	33.8	33.89	108012.0
2009-05-22 08:30:00	QQQ	ETF	33.9	33.9	33.82	33.82	155230.0
2009-05-22 09:00:00	QQQ	ETF	33.82	33.82	33.73	33.79	686187.0
2009-05-22 09:30:00	QQQ	ETF	33.78	33.81	33.32	33.51	14730207.0
2009-05-22 10:00:00	QQQ	ETF	33.51	33.78	33.44	33.7	9253359.0
2009-05-22 10:30:00	QQQ	ETF	33.71	33.79	33.59	33.74	5052420.0
2009-05-22 11:00:00	QQQ	ETF	33.74	33.87	33.68	33.79	4370151.0
2009-05-22 11:30:00	QQQ	ETF	33.8	33.82	33.69	33.74	2694079.0
2009-05-22 12:00:00	QQQ	ETF	33.74	33.83	33.65	33.65	3715963.0
2009-05-22 12:30:00	QQQ	ETF	33.65	33.86	33.65	33.84	3284980.0

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

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