PREVIEW / etf_30min / 2009-09-30

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-09-30.parquet
  size:    236 KB
  rows:    7,680

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-09-30 04:00:00	SPY	ETF	106.2	106.2	106.2	106.2	100.0
2009-09-30 04:30:00	SPY	ETF	106.32	106.45	106.32	106.45	12550.0
2009-09-30 05:00:00	SPY	ETF	106.54	106.54	106.41	106.41	4700.0
2009-09-30 05:30:00	SPY	ETF	106.41	106.44	106.41	106.42	4440.0
2009-09-30 06:00:00	SPY	ETF	106.47	106.47	106.37	106.37	25200.0
2009-09-30 06:30:00	SPY	ETF	106.32	106.39	106.32	106.34	2900.0
2009-09-30 07:00:00	SPY	ETF	106.34	106.4	106.25	106.35	50687.0
2009-09-30 07:30:00	SPY	ETF	106.36	106.46	106.29	106.39	228722.0
2009-09-30 08:00:00	SPY	ETF	106.29	106.45	105.94	106.24	1271182.0
2009-09-30 08:30:00	SPY	ETF	106.26	106.77	106.25	106.38	1697960.0
2009-09-30 09:00:00	SPY	ETF	106.38	106.4	106.08	106.36	2187341.0
2009-09-30 09:30:00	SPY	ETF	106.36	106.46	104.62	104.81	42903930.0
2009-09-30 10:00:00	SPY	ETF	104.81	106.25	104.66	104.84	17971530.0
2009-09-30 10:30:00	SPY	ETF	104.85	104.97	104.71	104.899	11991963.0
2009-09-30 11:00:00	SPY	ETF	104.9	105.31	104.88	105.245	10903188.0
2009-09-30 11:30:00	SPY	ETF	105.24	105.44	105.08	105.32	8828086.0
2009-09-30 12:00:00	SPY	ETF	105.32	105.54	105.23	105.5	8530841.0
2009-09-30 12:30:00	SPY	ETF	105.5	106.02	105.5	105.92	16357369.0
2009-09-30 13:00:00	SPY	ETF	105.91	106.38	105.91	106.15	15274308.0
2009-09-30 13:30:00	SPY	ETF	106.14	106.22	105.92	106.03	7730685.0
2009-09-30 14:00:00	SPY	ETF	106.0399	106.15	105.88	106.0117	5216873.0
2009-09-30 14:30:00	SPY	ETF	106.01	106.25	105.72	105.74	11897777.0
2009-09-30 15:00:00	SPY	ETF	105.73	105.8	105.15	105.3	21850998.0
2009-09-30 15:30:00	SPY	ETF	105.3	105.9	105.21	105.59	35880128.0
2009-09-30 16:00:00	SPY	ETF	105.61	106.24	104.69	105.76	16794202.0
2009-09-30 16:30:00	SPY	ETF	105.78	106.085	105.62	105.7	8936662.0
2009-09-30 17:00:00	SPY	ETF	105.69	105.72	105.64	105.69	127476.0
2009-09-30 17:30:00	SPY	ETF	105.69	105.72	105.64	105.65	210331.0
2009-09-30 18:00:00	SPY	ETF	105.67	105.7	105.56	105.62	204088.0
2009-09-30 18:30:00	SPY	ETF	105.62	105.82	105.62	105.82	84000.0
2009-09-30 19:00:00	SPY	ETF	105.82	105.87	105.8	105.83	28330.0
2009-09-30 19:30:00	SPY	ETF	105.81	105.9	105.79	105.9	33436.0
2009-09-30 06:00:00	QQQ	ETF	42.42	42.43	42.4	42.43	20500.0
2009-09-30 06:30:00	QQQ	ETF	42.41	42.42	42.41	42.42	5100.0
2009-09-30 07:00:00	QQQ	ETF	42.38	42.42	42.37	42.4	28234.0
2009-09-30 07:30:00	QQQ	ETF	42.4	42.43	42.4	42.43	77100.0
2009-09-30 08:00:00	QQQ	ETF	42.4	42.42	42.28	42.35	404145.0
2009-09-30 08:30:00	QQQ	ETF	42.37	42.51	42.34	42.44	609347.0
2009-09-30 09:00:00	QQQ	ETF	42.43	42.44	42.22	42.39	520689.0
2009-09-30 09:30:00	QQQ	ETF	42.39	42.49	41.6	41.75	27874483.0
2009-09-30 10:00:00	QQQ	ETF	41.74	41.83	41.68	41.8101	14587450.0
2009-09-30 10:30:00	QQQ	ETF	41.82	41.87	41.75	41.8001	7224744.0
2009-09-30 11:00:00	QQQ	ETF	41.8001	42.0	41.79	41.96	6144840.0
2009-09-30 11:30:00	QQQ	ETF	41.96	42.12	41.94	42.07	5928764.0
2009-09-30 12:00:00	QQQ	ETF	42.08	42.19	42.01	42.1601	7401815.0
2009-09-30 12:30:00	QQQ	ETF	42.1699	42.49	42.16	42.41	14061947.0
2009-09-30 13:00:00	QQQ	ETF	42.42	42.6024	42.42	42.47	9958243.0
2009-09-30 13:30:00	QQQ	ETF	42.47	42.5001	42.36	42.42	8309056.0
2009-09-30 14:00:00	QQQ	ETF	42.4101	42.45	42.35	42.4	3908818.0
2009-09-30 14:30:00	QQQ	ETF	42.39	42.48	42.26	42.26	8585192.0

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

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