PREVIEW / etf_30min / 2009-01-02

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-01-02.parquet
  size:    196 KB
  rows:    6,290

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-01-02 04:30:00	SPY	ETF	89.99	89.99	89.99	89.99	100.0
2009-01-02 05:30:00	SPY	ETF	90.01	90.14	90.01	90.1	1400.0
2009-01-02 06:00:00	SPY	ETF	90.1	90.82	90.0	90.78	44600.0
2009-01-02 06:30:00	SPY	ETF	90.77	90.96	90.66	90.75	19840.0
2009-01-02 07:00:00	SPY	ETF	90.79	90.9	90.64	90.66	104724.0
2009-01-02 07:30:00	SPY	ETF	90.66	90.72	90.55	90.62	61951.0
2009-01-02 08:00:00	SPY	ETF	90.64	90.74	89.96	90.05	1508304.0
2009-01-02 08:30:00	SPY	ETF	90.05	90.32	89.98	90.22	765162.0
2009-01-02 09:00:00	SPY	ETF	90.22	90.51	90.15	90.45	1759384.0
2009-01-02 09:30:00	SPY	ETF	90.44	90.66	89.85	90.08	22998889.0
2009-01-02 10:00:00	SPY	ETF	90.07	90.79	89.92	90.75	15196821.0
2009-01-02 10:30:00	SPY	ETF	90.75	91.57	90.68	91.52	16479057.0
2009-01-02 11:00:00	SPY	ETF	91.53	91.67	91.33	91.6575	14558298.0
2009-01-02 11:30:00	SPY	ETF	91.6517	91.85	91.55	91.63	10739864.0
2009-01-02 12:00:00	SPY	ETF	91.63	91.82	91.56	91.76	7566089.0
2009-01-02 12:30:00	SPY	ETF	91.75	92.13	91.73	91.93	12435714.0
2009-01-02 13:00:00	SPY	ETF	91.92	92.38	91.85	92.34	10423877.0
2009-01-02 13:30:00	SPY	ETF	92.35	92.57	92.23	92.36	10405645.0
2009-01-02 14:00:00	SPY	ETF	92.36	92.64	92.14	92.63	14126381.0
2009-01-02 14:30:00	SPY	ETF	92.63	92.92	92.55	92.79	20605856.0
2009-01-02 15:00:00	SPY	ETF	92.79	93.13	92.78	93.07	20351565.0
2009-01-02 15:30:00	SPY	ETF	93.1	93.44	92.9	92.97	37555004.0
2009-01-02 16:00:00	SPY	ETF	92.99	93.05	91.14	92.83	7839100.0
2009-01-02 16:30:00	SPY	ETF	92.82	92.83	92.66	92.69	164758.0
2009-01-02 17:00:00	SPY	ETF	92.69	92.75	92.67	92.7	48183.0
2009-01-02 17:30:00	SPY	ETF	92.7	92.75	92.65	92.65	15074.0
2009-01-02 18:00:00	SPY	ETF	92.69	92.71	92.69	92.71	2414.0
2009-01-02 18:30:00	SPY	ETF	92.72	92.83	92.72	92.78	26309.0
2009-01-02 19:00:00	SPY	ETF	92.78	92.83	92.67	92.67	28667.0
2009-01-02 19:30:00	SPY	ETF	92.68	92.77	92.67	92.77	6282.0
2009-01-02 06:00:00	QQQ	ETF	29.84	29.95	29.84	29.95	400.0
2009-01-02 06:30:00	QQQ	ETF	29.93	29.96	29.93	29.96	800.0
2009-01-02 07:00:00	QQQ	ETF	29.93	29.98	29.88	29.88	1753.0
2009-01-02 07:30:00	QQQ	ETF	29.9	29.92	29.86	29.89	21562.0
2009-01-02 08:00:00	QQQ	ETF	29.88	29.9	29.59	29.59	1333657.0
2009-01-02 08:30:00	QQQ	ETF	29.61	29.74	29.59	29.67	193298.0
2009-01-02 09:00:00	QQQ	ETF	29.65	29.78	29.64	29.78	350626.0
2009-01-02 09:30:00	QQQ	ETF	29.77	29.91	29.69	29.8099	9173239.0
2009-01-02 10:00:00	QQQ	ETF	29.8	30.03	29.75	30.0	9608259.0
2009-01-02 10:30:00	QQQ	ETF	30.0	30.37	29.9	30.3405	9845425.0
2009-01-02 11:00:00	QQQ	ETF	30.34	30.37	30.25	30.35	5539984.0
2009-01-02 11:30:00	QQQ	ETF	30.36	30.47	30.32	30.41	5820034.0
2009-01-02 12:00:00	QQQ	ETF	30.42	30.5	30.38	30.49	4345305.0
2009-01-02 12:30:00	QQQ	ETF	30.49	30.65	30.49	30.59	5344014.0
2009-01-02 13:00:00	QQQ	ETF	30.59	30.72	30.55	30.7	4514002.0
2009-01-02 13:30:00	QQQ	ETF	30.7	30.8	30.67	30.71	4803669.0
2009-01-02 14:00:00	QQQ	ETF	30.72	30.85	30.64	30.82	5886863.0
2009-01-02 14:30:00	QQQ	ETF	30.83	30.93	30.8	30.87	7004023.0
2009-01-02 15:00:00	QQQ	ETF	30.86	30.97	30.86	30.94	5437918.0
2009-01-02 15:30:00	QQQ	ETF	30.945	31.13	30.35	31.02	18978815.0

> showing 50 of 6,290 rows — these rows as CSV

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